Session 3: Automating the DBA's Workload


Presented by: Allen White 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.

Buy This On-Demand Training Now!

This video is part of the SQL Server Database Administration with PowerShell On Demand training.

This class will first introduce you to PowerShell, after which you'll learn the basic SMO object model, how to manipulate data with PowerShell, and how to use SMO to manage objects. We'll then move on to creating Policy-Based Management policies, working with the Central Management Server, managing your system inventory, and gathering performance data with PowerShell.

Buy This On-Demand Training Now!

To gain access this event, please register through our On-Demand Training catalog.

Already purchased this? to view your content.
John Savill Windows 10 Training

Developing and Implementing a Windows 10 Business Strategy​
Live Online Training on Tuesday, October 25th 
Register by October 19th and Save 15%!

Many organizations today are exploring adoption of Windows 10. Often touted as the last version of Windows, it is now a constantly evolving Windows as a Service solution. In this one-day training, you'll find out what this new model for Windows really means to your organization and what the benefits are once you've made the move to Windows 10.


Join the Conversation

Sponsored Introduction Continue on to (or wait seconds) ×