Session 3: Automating the DBA's Workload

Presented by: Allen White

Running Time: 116 min

An introduction to Policy-Based Management and a demonstration of how to set up PBM using PowerShell, followed by a walkthrough of the registered server and Central Management Server setup via scripts. Then a discussion of maintaining a server inventory and gathering SQL Server performance data via PowerShell, and a demonstration on using PowerShell Remoting to manage multiple servers simultaneously.

Click Here to Download Slides

Click Here to for Demo Scripts