About MSSQL ..updation in progress
Databases ..updation in progress
Data Storage
Indexes
Transactional Log
Memory Management
Backup & Restore
Standby Server (DR) ..updation in progress
Profiler
Administration and Monitoring Scripts
Miscellaneous
Tricks and tactics
SQL Queries for DBA
DBCC Database Consistency Checker
All about Error Log
Setting Up DR using Log Shipping and DR Drill
SQL starting instance in single user mode and getting admin console
DBCC - Dealing with Page Corruption
Index Rebuild and Re-org
ShrinkDatabase and Database Size Managment.
User/Logins Backup and Restoration
Restoring the master database from backup
Emergency Mode
Setting MSSQL Cluster ..updation in progress
SQL Server 2008