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 Adventure Works 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.
Unable to display preview. Download preview PDF.