O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing the SQL Server Best Practices Analyzer

A best practice is a task or set of steps that best meet particular needs within the day-to-day administrative tasks. As a DBA, you must evaluate the commonly accepted practices, best practices and determine the best ones to apply to the environment.

To implement best practices, we should first evaluate and analyze if the existing environment is managed efficiently according to the practices accepted in the industry. There are plenty of tools available that enable the user to analyze the system on a particular set of best practices.

For SQL Server environments, Microsoft is offering two sets of tools that will help DBAs to analyze the set of SQL Server instances and recommend best practices to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required