22-25 April 2026 
Database Maintenance Optimization
2009TL; DR
Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance. In this session, you will learn the key things all DBAs need to know in order to maintain their databases at peak performance.
Session Details
Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance. In this session, you will learn the key things all DBAs need to know in order to maintain their databases at peak performance, including:
- Physical File Defragmentation
- Database and Log File Management
- tempdb Maintenance
- msdb Maintenance
- Index Maintenance
- Statistics Maintenance
- Data Corruption Detection
- Database and Log File Protection
- Database Maintenance Monitoring
3 things you'll get out of this session
Speakers
Brad McGehee's previous sessions
Back From the Dead: How to Restore a SQL Server in 60 Minutes or Less
In this session, I will demonstrate, step-by-step, the entire process of restoring all of the system and user databases from a damaged instance to a new instance.
How to Perform a SQL Server Health Check
You will learn about a comprehensive checklist you can use to verify a SQL Server’s health, which you can use to help you determine if the instance is running optimally and is highly available.