Multimedia Library

rss All Multimedia (131) Gallery (33) Video (98)
Jul 23, 2014
Education

Session 2: Optimizing SQL Server Performance in a Virtual Environment  

Running Time: 60 minutes | In this session, we'll look over what you should look at within your virtual environment to ensure you are getting proper performance. This will include how to look for CPU performance issues at the host level. We'll also discuss the Memory Balloon drivers – what they do, how you should configure them, and why. We'll discuss memory sharing technologies, which are built into vSphere and Hyper-V, and how they relate to SQL Server. Then we'll will finish with some storage configuration options....More
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 1: Power BI Platform: Technical Overview  

Running Time: 64 minutes | In this session, Jen will introduce the Power BI Platform components from a BI professional perspective. She will cover key differences from the prior Power BI release, various BI delivery use cases, and deployment models. Best practices and recommendations also will be shared....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
Jul 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 29: Practical Implementation Tips

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More
Jul 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations – meaning that most of the code and examples I’ve provided up until this point were based on assumptions about how CHANGE to jobs is managed. That pessimism, to date, has come in two forms:...More
Jul 1, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 27: Options and Concerns for More Advanced Deployments

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL Server Agent jobs – both in the form of Batch Jobs (see post #3) and backups....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) ×