CHAPTER 2

image

Tools of the Trade

SQL Server 2012 comes with a wide selection of tools and utilities to make development easier as enhancing productivity of the developers is one of the key areas of focus in SQL Server 2012. In this chapter, we will introduce some of the most important tools for SQL Server developers, including SQL Server Management Studio (SSMS) and the SQLCMD utility, SQL Server Data Tool add-ins to Microsoft Visual Studio, SQL Profiler, Database Tuning Advisor, Extended Events, and SQL Server 2012 Books Online (BOL). We will also introduce supporting tools like SQL Server Integration Services (SSIS), the Bulk Copy Program (BCP), ...

Get Pro T-SQL 2012 Programmer's Guide, Third Edition now with O’Reilly online learning.

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