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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
