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 …
Rob Farley Interview – Database Corruption Challenge Read more »
Now that the Database Corruption Challenge has come to an end, I am looking for some feedback from the participants to see what we can do next (if anything) and to learn from the experience. I have created a survey, …
Today I am proud to announce that the Database Corruption Challenge has come to an end. I would like to say that I have met some really great people during this contest and I look forward to seeing you at …
Announcing the Database Corruption Challenge Winners Read more »
Is a clustered table in SQL Server a BTree or Linked List? When you first learn about the structure behind clustered indexes in SQL Server, you find out that the clustered index is structured as a type of B+Tree where queries that …
Welcome to Week 10 of the Database Corruption Challenge. I have created a more corrupt, and perhaps more diabolical corruption scenario than previous weeks. This is the last week of 10 in the Database Corruption Challenge. Here is how it …
The Database Corruption Challenge – Grand Finale The final challenge #10 in the Database Corruption Challenge starts this Friday (July 17th) at 6:00pm (Pacific Time). After 9 other challenges we come to the final competition in this series. Many have …
Database Corruption Challenge #10 Grand Finale – Starts Friday Read more »
I was asked how I caused the corruption in Database Corruption Challenge #9. Here is how I did it. To cause the corruption, I used the undocumented DBCC WritePage, however the same thing could have been accomplished by detaching the …
Database Corruption Challenge #9 – How I Corrupted the Database. 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 …
With the recent release of Database Health Monitor Version 2.0 I have decided to focus on of blogging about the features and benefits of the Database Health Monitor application. There are some incredibly valuable features that are often overlooked. The …
Just about 24 hours after releasing Database Corruption Challenge #9, so far there have been 15 winning solutions. The first to submit a winning solution was Eduardo Rezende. The scores have been updated. Rob Farley is back in the lead with 18 …