SQL Server Tools Tutorials
Microsoft SQL Server 2005 includes a complete set of graphical tools and command line utilities that allow users, programmers, and administrators to increase their productivity. The step-by-step tutorials listed below, help you learn to get the most out of SQL Server tools so you can work efficiently, right from the start. The following table describes the topics in this section. Click a link to start a tutorial.
- SQL Server Management Studio Tutorial
Take this tutorial to review how SQL Server Management Studio provides a rich and flexible work surface. Learn to configure the SQL Server Management Studio to support the way you work. Learn how to get more space on the desktop, how to use the great new features of the SQL Editor, manage script projects, and more. This tutorial is suitable for anyone who has not worked extensively in the Microsoft Visual Studio environment.
- sqlcmd Utility Tutorial
Use the sqlcmd utility, a command line utility, to run ad hoc Transact-SQL statements and scripts. Take this tutorial to get started. sqlcmd replaces osql and isql from earlier versions of SQL Server.
- Database Engine Tuning Advisor Tutorial
This tutorial will teach you how to tune a workload file with the Database Engine Tuning Advisor, and how to perform some basic tasks with the dta.exe command prompt utility.