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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access