After 10 weeks (or almost weekly) of corrupt databases, missing data and a challenging competition the Database Corruption Challenge finally comes to an end. As part of the last week of the challenge I created a short blog interview for the participants. This interview is Patrick Flynn. Patrick placed in third with a 3 way tie for third overall in the the Database Corruption Challenge scoring 21 …

Patrick Flynn Interview – Database Corruption Challenge Read more »

Database Corruption Challenge #9 has completed with 19 winning participants, you can take a look at the scoring page for exact details. The first to solve the challenge this week was Eduardo Rezende who provided the winning solution just 58 minutes after the challenge began. The second winning solution arrived less than a minute after the first, so it was a …

Database Corruption Challenge #9 Complete Read more »

With many participants and 16 who correctly solved Corruption Challenge week 8, the challenge has come to an end. The overall winner was Rob Farley, and there were several new participants this week. The scores page has been updated. Some participants called this the toughest challenge yet which makes my job even harder to come up with something more challenging …

Database Corruption Challenge #8 has Ended Read more »

Today I am presenting to the session “When Database Corruption Strikes” to the High Availability and Disaster Recovery PASS Virtual Chapter. Here is the abstract: 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 …

When Database Corruption Strikes Read more »

Today I had the opportunity to present When Corruption Strikes to the PASS DBA Virtual Chapter Meeting.  This was a lot of fun to be able to recap the previous 4 weeks of the Database Corruption Challenge, and share some of the ways to fix the corrupt database. I hope that everyone learned something that will help them when one day they …

Corruption Presentation Read more »

Welcome to the Week 5 Corruption Challenge.  If you have seen the t-shirt that I designed for the winner at the end of the 10 week period, please take a look. We are currently at the 5 week midpoint of the 10 week challenge. This challenge requires that you use the exact matching version of SQL Server for the challenge. …

Week 5 – Corruption Challenge Read more »