Chapter 4. Policy-Based Management Using PowerShell

PowerShell is a very useful scripting tool that enables system administrators to automate server administration, gather information, and deploy applications. Microsoft introduced support for Windows PowerShell version 1 with SQL Server 2008, and support for Windows PowerShell version 2 will be released with SQL Server 2008 Release 2.

In this chapter, we will create some basic PowerShell scripts to demonstrate how to use this tool with Policy-Based Management. We will use PowerShell to run a single policy against a single instance of SQL Server, and then to run a group of policies against a single instance of SQL Server. We will then store and query the policy results. Finally, we will tie in the ...

Get Pro SQL Server 2008 Policy-Based Management now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.