Multimedia Library

rss All Multimedia (120) Gallery (33) Video (87)
Jul 23, 2014
IdeaXchange

Session 3: Essential Monitoring Groups  

Running Time: 68 minutes | We'll demonstrate how to use the built-in DMV’s to query the information you need to monitor the core areas of SQL Server—which can help you to decide how well or poorly these areas may be performing at any given time. By concentrating on these core aspects on a regular basis, you can often keep ahead of the game without being overwhelmed by the otherwise massive amounts of data to collect and analyze....More
Jul 23, 2014
Education

Session 1: Understanding the Power BI Components  

Running Time: 88 minutes | Walking through an end-to-end example, you'll learn how Power BI starts in Excel (Power Query, PowerPivot, Power View, and Power Map) and extends to Office 365 to allow organization to share and collaborate BI solutions....More
Jul 23, 2014
Education

Session 2: Designing Large Cubes  

Running Time: 60 minutes | In this session, you will learn specific techniques for designing dimensions and cubes to optimize the storage and retrieval of large data....More
Jul 23, 2014
Education

Session 1: SQL Recovery Models and Backups  

Running Time: 59 minutes | This session will answer the following questions: What are full, simple, and bulk-logged recovery? What are the differences between full, transaction log, differential, or filegroup backups? What is a piecemeal restore? What is a stripped backup and how does it speed things up? What is a VLF and how does VLF fragmentation affect my SQL Server? How do VLF’s affect AlwaysOn, mirroring, change data capture, or use transactional replication? This session will cover these topics and more....More
Jul 23, 2014
Education

Session 2: Catalog Features  

Running Time: 70 minutes | An exploration of SSIS Catalog functionality applied to the modern data integration enterprise, featuring discussion and demonstrations of SSIS project and package parameters, SSIS project connection managers, and SSIS Catalog environments and references....More
Jul 23, 2014
Education

Session 3: Using Service Broker to do ETL from an OLTP Database  

Running Time: 67 minutes | Most of the time you'll see Extract, Transform, Load (ETL) being done with a tool such as SSIS, but what if you need near-real time reporting? This session will demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database....More
Jul 23, 2014
Education

Session 3: Using Storage to Increase Database Performance  

Running Time: 60 minutes | In the final session, we'll look at ways that your storage solution can be configured to increase database performance. Some of the things to consider when selecting the correct RAID level to use will be highlighted, along with a review of how to setup the cache in your storage array or DAS. We'll then look at some of the newer technologies like FLASH Cache to improve the caching abilities of the storage arrays. Finally, you'll learn some of the differences between iSCSI and Fibre Channel and how to use tiered storage from both a performance and finance perspective....More
Jul 23, 2014
Education

Session 1: Writing Cleaner Code  

Running Time: 88 minutes | This session will examine ways to write better code by using CTEs to simplify queries, implement error handling to deal with problematic data, and show a few tips and tricks for writing code quicker and generating enough test data to properly evaluate your queries....More
Jul 23, 2014
Education

Session 2: Power BI for Office 365 Administration  

Running Time: 79 minutes | We'll install and configure Office 365 on the desktop, then setup and configure a new Power BI for Office 365 tenant. This session will also cover the Power BI for Office 365 licensing and site provisioning requirements....More
Jul 23, 2014
Education

Session 3: Implementing Large Cubes  

Running Time: 63 minutes | In this session, we teach you how best to manage cube processing when you need to load fresh data....More

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×