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 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.