CHAPTER 2

image

Tools of the Trade

SQL Server 2014 comes with a wide selection of tools and utilities to make development easier and more productive for developers. This chapter introduces 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 2014 Books Online (BOL). You’re also introduced to supporting tools like SQL Server Integration Services (SSIS), the Bulk Copy Program (BCP), and the AdventureWorks 2014 sample database, which you use in examples ...

Get Pro T-SQL Programmer’s Guide, 4th Edition 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.