C H A P T E R  3

What’s in the Toolbox?

If installing Microsoft SQL Server gave you only 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

For a DBA, SQL Server Management Studio (SSMS) is arguably the most frequently 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 Compact, SQL Server Reporting Services, SQL Server Integration ...

Get Beginning SQL Server 2012 Administration now with O’Reilly online learning.

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