C H A P T E R  2

SQL Server Management Studio

Now that SQL Server 2012 is successfully installed on your machine, it is time to start exploring the various areas that make this an easy and effective product to use. With SQL Server, all the administration interfaces reside in studios, such as SQL Server Management Studio, which features tools for working with developing database solutions. This chapter concentrates on SQL Server Management Studio (SSMS), which you will use to develop and maintain your databases and the objects SSMS contains.

SSMS is the graphical user interface (GUI) you will use to build your database solutions. This is an easy-to-use and intuitive tool, and before long, you will feel confident in using it to work with SQL Server quickly and efficiently. I will be discussing several aspects of SSMS in this chapter. You can then use this knowledge throughout the book. I'll discuss some aspects in more detail throughout the book.