Chapter 8. Policy-based management

The major goal of this book is to list and describe best practices for the administration of SQL Server systems. Knowing best practices is one thing, but ensuring they're implemented, and remain implemented, is an entirely different matter.

Suppose you've accepted a position as the new DBA for a company with thousands of server instances spread across production, test, and development environments, each of which were installed and configured by various DBAs and developers with different preferences and knowledge of best practices. If you're asked to perform an audit of all servers for compliance with best practices, how will you go about it? If you're handy with scripting technologies such as SQL Server Management ...

Get SQL Server 2008 Administration in Action 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.