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.
KeywordsExecution Plan Startup Script Erver Data
Unable to display preview. Download preview PDF.