Database Engine Administrator InfoCenter

In Microsoft SQL Server 2008, a Database Engine administrator plans and runs the daily operations of instances of the Database Engine in such areas as system availability, performance monitoring and optimization, deployment, upgrades, troubleshooting, and configuration. Small and medium organizations may have only one administrator; larger organizations may subdivide the administrator role into multiple job titles. For more information see Troubleshooting (Database Engine).

To help the administrator of the Database Engine be as effective as possible, the following lists provide links to those topics considered most useful for the maintenance and optimization of instances of the Database Engine.

Note

Database design is classified as a developer activity. For more links related to database design, see the Database Engine Developer InfoCenter.

Concepts Administration (Database Engine) Viewing Database Metadata Metadata Visibility Configuration Monitoring Events Documenting and Scripting Databases Scripting Jobs Using Transact-SQL Working with the Database Engine Mapping System Tables to System Views (Transact-SQL) Configuring SQL Server 2008 Automating Administrative Tasks (SQL Server Agent) Dynamic Management Views and Functions (Transact-SQL) Query Performance Introduction to Backup and Restore Strategies in SQL Server Optimizing Backup and Restore Performance in SQL Server Optimizing Bulk Import Performance Detaching and Attaching Databases How to: Upgrade SQL Server with the Copy Database Wizard How to: Upgrade a Database Using Detach and Attach (Transact-SQL) Overview (Integration Services) About Bulk Import and Bulk Export Operations Languages Transact-SQL Reference (Database Engine) SQL Server Management Objects (SMO) Tools Introducing SQL Server Profiler Understanding Database Engine Tuning Advisor Tuning the Physical Database Design Maintenance Plans SQL Server Management Studio Using the sqlcmd Utility

More InformationSQL Server Database EngineInstalling the Database Engine Considerations for Installing the SQL Server Database Engine Installing SQL Server 2008 Components Considerations for Installing Analysis Services Considerations for Installing Integration Services Considerations for Installing Reporting Services Security Security and Protection (Database Engine) International Considerations Setting and Changing Collations Tutorials and Walkthroughs Tutorial: Getting Started with the Database Engine Tutorials Tutorial: Writing Transact-SQL Statements Tutorial: Database Engine Tuning Advisor Tutorial: sqlcmd Utility Troubleshooting Troubleshooting an Installation of SQL Server Troubleshooting (Database Engine) External Resources SQL Server TechNet