Intro to Policy-Based Management and Central Management Server

SQL Rally slide deck is avaiable here.

SQL Satuday in Houston slide deck is avaiable here (1.5MB pdf).

You can download the slide deck and sample scripts from SQL Saturday #61 in DC here.

Central Management Examples

• Configure your first Central Management Server
• Automate the validation of a Daily Full backups with Powershell, CMS and T-SQL

White Papers

• Administering Servers by Using Policy-Based Management
• Enterprise Policy Management Framework with SQL Server 2008
• SQL Server 2008 Policy-Based Management

Book

• Pro SQL Server 2008 Policy-Based Management (Expert’s Voice in SQL Server)

Web

• mssqltips – Policy-Based Management
• Central Management Servers, have you seen these? – Kimberly Tripp
• Central Management Server on SQLServerPedia – Brent Ozar
• SQL Server Policy Based Management blog

Policies

• Validate SQL Server Backups Exist with Policy Based Management – Thomas LaRock (blog | @SQLRockstar)

PowerShell References

• SQLUniversity PowerShell Day #5 – Loop through registered servers – Aaron Nelson (blog | @SQLVariant)
• The Scripting Guys
• Allen White
• Sean McCown