Advertisement

Tools of the Trade

  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

Abstract

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), and the AdventureWorks 2012 sample database, which we will use in examples throughout the book.

Keywords

Execution Plan Startup Script Erver Data 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Jay Natarajan, Rudi Bruchez, Scott Shaw, and Michael Coles 2012

Authors and Affiliations

  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

There are no affiliations available

Personalised recommendations