Chapter 8. Policy-based management

 

In this chapter, we’ll cover

  • Enterprise DBA challenges
  • Policy-based management
  • Central management servers
  • PowerShell and ExecuteWQL()

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 Objects (SMOs) and PowerShell, that will certainly help, but other than that, you’re facing a significant and time-consuming challenge. When you finally complete the exercise, how can you be confident that none of the servers have changed configuration since you started inspecting them? Like painting a bridge, by the time you finished you’d be due to start all over again!

8.1. Server management challenges

8.2. Policy-based management terms

8.3. Policies in action

8.4. Enterprise policy management

8.5. Advanced policy-based management

8.6. Best practice considerations: policy-based management