O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Tools and Utilities

Enhancements have been made to many of the SQL Server administration tools and utilities. The previous Enterprise Manager has been replaced with the SQL Server Management Studio, Query Analyzer replaced with Query Editor (part of SQL Server Management Studio), and the osql command line utility with sqlcmd. In addition, the new configuration utility called SQL Server Configuration Manager rolls three previous tools—Server Network Utility, Client Network Utility, and Service Manager—into one. Also, the previous Index Tuning Wizard has been replaced by the new Database Engine Tuning Advisor tool. The SQL Profiler tool still exists but with several enhancements and a different look, and there is a new tool called SQL Server Surface ...

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