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