Chapter 3. Reviewing Microsoft SQL Server 2005 Management Tools

After completing this chapter, you will be able to:

  • Use SQL Server Books Online

  • Use SQL Server Configuration Manager

  • Use SQL Server Surface Area Configuration

  • Use SQL Server Management Studio

  • Use SQL Server Profiler

  • Use Database Engine Tuning Advisor

  • Use SQLCmd

Introduction

Using Microsoft SQL Server 2005 does not only involve the creation and development of databases, tables, indexes, and stored procedures. Many tools are available to help you analyze behavior, enable features, and study and enhance the performance of your server. This chapter will acquaint you with all of these tools so that you will discover where to find the exact information you need and achieve the best results during ...

Get Microsoft® SQL Server™ 2005: Database Essentials Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.