Summary

In this chapter, you have learned about the new suite of graphical and command-line tools introduced in SQL Server 2005.

The new SQL Server Management Studio consolidates the functionality provided by Enterprise Manager, Query Analyzer, and Analysis Manager. The new Business Intelligence Development Studio supports the complete business intelligence development life cycle by providing integrated tools to integrate, analyze, and report. The free SQL Server edition, SQL Server 2005 Express Edition, now bundles graphical tools such as Express Manager that can be used to manage server and author queries.

SQL Profiler is enhanced to support SQL Server 2005 features and also to provide better information to aid in troubleshooting performance issues. The Index Tuning Wizard from the previous release has now been replaced with a brand-new application called the Database Engine Tuning Advisor that assists in physical database design by recommending indexes, indexed views, and partitioning.

The new SQL Server Configuration Manager integrates Service Manager, Server Network Utility, and Client Network Utility into one application. SQLCMD is the new command-prompt utility that replaces osql.exe and also contains better scripting support. SQL Server 2005 introduces a SMTP-based emailing solution called Database Mail that provides a scalable, reliable, and secure method of sending emails.

The final section in this chapter shows you how to automate management tasks by using SMO and WMI. Chapter 6, "Transact-SQL Enhancements," describes the new features and enhancements introduced in the T-SQL language.