Chapter 3. Using the Tools in SQL Server 2008

After completing this chapter, you will be able to

  • Select the appropriate SQL Server 2008 tool for a given task

  • Manage SQL Server 2008 services

  • Launch, navigate, and utilize SQL Server Management Studio

  • Utilize several shortcuts for better productivity

  • Configure Database Mail

SQL Server 2008 ships with eight stand-alone tools used to configure, manage, and monitor SQL Server services. Within this group of eight core tools, you can also design SQL Server objects and execute code. The most wide-reaching tool, SQL Server Management Studio (SSMS), contains four additional tools designed for management and monitoring.


You can install instances of SQL Server Integration Services, Reporting Services, Analysis ...

Get Microsoft® SQL Server® 2008 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.