The topics in this section provide information about how to perform tasks related to the SQL Server 2005 Database Engine by using SQL Server Management Studio, Transact-SQL, SQL Server Configuration Manager, SQL Server Profiler, command-prompt utilities, and other tools and wizards.
In This Section
|
Topic
|
Description
|
| Database Creation and Design How-to Topics | How to create databases, database snapshots, and indexes. |
| Administration How-to Topics | How to manage services, configure availability, back up and restore databases, manage servers and server connectivity, and configure clients. |
| Automated Administration How-to Topics (SQL Server Management Studio) | How to define jobs and alerts in SQL Server Management Studio. |
| Automated Administration How-to Topics (Transact-SQL) | How to define jobs and alerts with Transact-SQL stored procedures. |
| Performance Monitoring and Tuning How-to Topics | How to monitor SQL Server performance and user activity, tune the design of databases for optimal performance, and view query execution plans. |
| Visual Database Tools How-to Topics | How to use the Visual Database Tools Database Designer, Table and View Designer, and Query Designer. |