O'Reilly logo

Pro T-SQL 2008 Programmer's Guide by Michael Coles

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required