Multimedia Library - All

Sep 14, 2015
Video
Windows IT Pro

Automating Azure with PowerShell: Beyond the Azure PowerShell Module  

Michael S. Schultz Neil Peterson...More
Sep 14, 2015
Video
Windows IT Pro

Diving into Clustering Changes in Windows Server vNext  

Speaker: John Savill This session looks at all the changes in Windows Server vNext failover clustering, including new quorum options that leverage Microsoft Azure, changes to behavior when nodes can't communicate, hosting Hyper-V VMs, rolling upgrade (at last) capabilities, and much more....More
Sep 14, 2015
Video
Windows IT Pro

Managing Microsoft Azure IaaS with Windows PowerShell DSC  

Speaker: Aleksandar Nikolic When you need to quickly provision and reliably manage your Microsoft Azure environment, nothing beats automation. Learn how to manage Microsoft Azure virtual machines and prevent their configuration drift by using Windows PowerShell Desired State Configuration. We'll demonstrate how to work with the components of Microsoft Azure infrastructure services, applying DevOps principles from the beginning to the end of life of your Microsoft Azure resources....More
Sep 14, 2015
Video
Windows IT Pro

Wake Your Inner Dev: PowerShell Desired State Configuration Resource Creation  

Speaker: David O'Brien / Trevor Sullivan Take a journey into the realm of developers, and learn to write custom DSC resource modules. Find out what resources are, how to create them, and why to create them. Discover that you don't really need to be a developer to create your own advanced DSC resources....More
Sep 14, 2015
Video
Windows IT Pro

A Day in the Life of a Row: Internals Deep Dive  

Speaker: Eddie Wuerch The SQL Server Query Processor does a great job of hiding all the dirty work necessary to display, store, and delete data. But when it's time to tune performance, the more you know, the better decisions you can make. In this T-SQL demo-heavy deep-dive session, we'll follow the Query Processor as it rips through a database and discover the steps it takes in responding to our queries.  ...More
Sep 14, 2015
Video
Windows IT Pro

Benchmarking Your SQL Server Environment  

Speaker: Ben DeBow/David Klee...More
Sep 14, 2015
Video
Windows IT Pro

Designing an SSIS Framework  

Speaker: Andy Leonard In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that integrates with the SSIS Catalog to manage package execution, connections, and centralized logging.  ...More
Sep 14, 2015
Video
Windows IT Pro

ELT with Pig: Managing Data Transformations in "Load First" Environments  

Speaker: Joshua Fennessy One of the key distinctions of so-called data lake (or enterprise data hub) scenarios is that data is first loaded to the environment, then transformed into useful information. This is often opposite of traditional EDW systems where the data must be transformed before it's loaded. In this Hadoop-focused session, we'll use an Apache project called Pig to load unformatted data and wrangle it into a fashion that can be used by data architects who might be building an EDW....More
Sep 14, 2015
Video
Windows IT Pro

Get Near Real-Time ETL with Service Broker  

Speaker: Allen White ETL is typically done with a tool such as SSIS; but what if you need near real-time reporting? You need to get the updates in your OLTP database to the data warehouse quickly, but with minimal impact on your application. Asynchronous messaging with Service Broker makes this task simple and painless. This session will walk through the basic transformations to build a Kimball-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database....More
Sep 14, 2015
Video
Windows IT Pro

Index Internals  

Speaker: Denny Cherry In this session we'll dig into the internal structures of indexes. We'll look at how SQL Server navigates through the index. We'll look at the various types of pages within the index and how SQL Server uses these different pages to access your data. We'll look at what happens within the index as data changes. This session will include numerous demos using undocumented commands as we dive into the depths of the database pages....More
John Savill's Azure Master Class

Join John Savill and become an Azure Master!

This 12 session Master Class will equip you with everything you need to understand, evaluate, deploy and maintain environments that utilize Microsoft Azure including hybrid scenarios.

Thursdays, August 4th through August 25th

Enroll by July 29th and SAVE $130!

 

Join the Conversation

Sponsored Introduction Continue on to (or wait seconds) ×