Learn about the Database Engine administration and operations tasks associated with the databases that you develop in Microsoft SQL Server 2008.
Managing Servers
DDL Triggers
Logon Triggers
Connecting to the SQL Server Database Engine
Managing the Database Engine Services
More…
High Availability Solutions Overview
Database Mirroring
Log Shipping
High Availability: Interoperability and Coexistence
Event Notifications (Database Engine)
Monitoring Resource Usage (System Monitor)
Monitoring Events
Data Collection
SQL Server Extended Events
Monitoring and Tuning for Performance
Performance Monitoring and Tuning How-to Topics
Query Performance
Managing SQL Server Workloads with Resource Governor