Chapter 3. Tools of the Trade

SQL Server 2008 comes with a wide selection of tools and utilities to make development easier. In this chapter, I will introduce some of the most important tools for SQL Server developers, including SQL Server Management Studio (SSMS) and the SQLCMD utility, Business Intelligence Development Studio (BIDS), SQL Profiler, and SQL Server 2008 Books Online (BOL). I will also introduce supporting tools like SQL Server Integration Services (SSIS), the Bulk Copy Program (BCP), and the AdventureWorks 2008 sample database, which I will use in examples throughout the book. I will also cover some of the SQL Server connectivity features of Visual Studio 2005 and 2008.

SQL Server Management Studio

Back in the heyday of SQL Server ...

Get Pro T-SQL 2008 Programmer's Guide now with O’Reilly online learning.

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