Microsoft® SQL Server 2008 R2 Unleashed

Summary

Policy-Based Management is a new component in SQL Server 2008 that allows you to manage your SQL 2000, 2005, and 2008 servers by creating policies that can be used to enforce compliance to best practices or to report on out-of-compliance servers. It provides a highly granular, flexible, and extensible toolset that allows you to manage all aspects of your SQL Server. Properly used, it is a great tool to enforce standardization in your environment and to ease the management burden.

The next part of this book, Part IV, “Database Administration,” explores the tasks involved in creating and managing databases and database objects, just the sorts of things you want to apply many of your best practices and policies against.