This Saturday, September 12th, 2015 I will be presenting at SQL Saturday Las Vegas. My presentation is on Database Corruption, here are the details.
When Database Corruption Strikes – Will you be ready?
Duration: 60 minutes
Track: Enterprise Database Administration & Deployment
You are working along month after month with no problems in your database. Suddenly someone reports that their query won’t run. They get an error stating “SQL Server detected a logical consistency-based I/O error“, or something even scarier. Do you know what to do now? We will walk through 3 or 4 actual corrupt databases exploring ways to go about finding and fixing the corruption. More importantly we will explore how to prevent further data loss at the time corruption occurs. Learn what things you should do to protect yourself when corruption strikes. Learn what to avoid that will make things worse. You will leave with a checklist of steps to take when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.
The presentation is scheduled for 11:00 am to Noon in room 2767 at the College of Southern Nevada campus in Vegas.
During this presentation I will show 3 corrupt databases and walk through the steps to resolve the corruption with no data loss. The outline for the session is:
- Detecting Corruption
- Tracking Corruption (what has gone bad?)
- Before fixing or removing corruption
- Removing Corruption
- Examples (3)
If you have never encountered databases corruption, or you are a pro and resolving database corruption this session is for you.
This is currently one of my favorite sessions to present.
I hope to see you there on Saturday! This is going to be fun.