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.

Note

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

Get Microsoft® SQL Server® 2008 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.