Chapter 3. What's in the Toolbox?

If all installing Microsoft SQL Server did was give you a database engine and nothing else, the management experience would be dismal at best. Luckily, Microsoft has shipped some relatively useful tools in conjunction with the database engine. In this chapter, you will explore most of the tools that are installed in a full installation of SQL Server.

SQL Server Management Studio

As a DBA, SQL Server Management Studio (SSMS) is arguably the most used tool of any provided by Microsoft for use with SQL Server. SSMS is the main tool for querying and managing all the products in SQL Server including the SQL Server database engine, SQL Server Mobile, SQL Server Reporting Services, SQL Server Integration Services, and ...

Get Beginning SQL Server 2008 Administration 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.