Advertisement

Tools of the Trade

  • Miguel Cebollero
  • Jay Natarajan
  • Michael Coles
Chapter

Abstract

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 throughout the book.

Keywords

Execution Plan Visual Studio Extended Event Query Plan Code Snippet 
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.

Copyright information

© Miguel Cebollero 2015

Authors and Affiliations

  • Miguel Cebollero
    • 1
  • Jay Natarajan
    • 1
  • Michael Coles
    • 1
  1. 1.ValricoUnited States

Personalised recommendations