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
Sep 1, 2015
blog

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015
blog

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
Aug 19, 2015
blog

Looking forward to Containers

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sense that a single, physical, can easily be divided up into multiple logical (or virtual) volumes (or drives) just as easily as a number of discreet physical disks can also be virtualized into a single drive (via RAID) – which can further be partitioned into volumes, LUNs, and so....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) ×