MSSQL

• 1. About MSSQL ..updation in progress

  2. Databases ..updation in progress

  3. Data Storage

1. Indexes

   1. Transactional Log

2. Memory Management

• 1. Backup & Restore

  2. Standby Server (DR) ..updation in progress

3. Profiler

4. Administration and Monitoring Scripts

• 1. Miscellaneous

5. Tricks and tactics

6. SQL Queries for DBA

7. DBCC Database Consistency Checker

8. All about Error Log

Miscellaneous

1. Setting Up DR using Log Shipping and DR Drill

2. SQL starting instance in single user mode and getting admin console

   1. DBCC - Dealing with Page Corruption

   2. Index Rebuild and Re-org

   3. ShrinkDatabase and Database Size Managment.

   4. User/Logins Backup and Restoration

   5. Restoring the master database from backup

3. Emergency Mode

• 1. Setting MSSQL Cluster ..updation in progress

SQL Server 2008