Beginning SQL Server 2008 Administration

Chapter 16. SQL Server in the Enterprise

Now that you are armed with the DBA knowledge presented thus far, how do you keep track of all the databases that you create and manage? Better yet, how do you monitor changes and ensure that your best practices are applied throughout the enterprise? It turns out that there's quite a bit of functionality to assist you in managing the data management environment in your enterprise.

Typically, in an enterprise environment, we are faced with managing multiple SQL Server instances and even more databases. Best practices dictate that we use a common approach for our entire environment. In the past, DBAs applied consistent management and monitoring in database environments by using manual processes. Today, certain ...