Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 Michael Coles
About this chapter
Cite this chapter
(2008). Tools of the Trade. In: Pro T-SQL 2008 Programmer’s Guide. Apress. https://doi.org/10.1007/978-1-4302-1002-3_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1002-3_3
Publisher Name: Apress
Print ISBN: 978-1-4302-1001-6
Online ISBN: 978-1-4302-1002-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books