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 PASS Summit in October, or other conference someday. The Corruption Challenge Winners After 10 competitions Rob Farley is the overall Champion …
Announcing the Database Corruption Challenge Winners Read more »
Week 10 Database Corruption Challenge specific details Timeline of events leading up to this database needing help: Date and times on the files are for July 14th 2015. At about 4:50pm you get an email from a developer reporting that when they query the orders table that it appears to have a lot more rows in it than they were expecting. They …
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, opening it with a hex editor, and then re-attaching the db. DBCC WritePage WARNING: DBCC WritePage is a dangerous …
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 after the challenge began. The second winning solution arrived less than a minute after the first, so it was a …
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 purpose of this blog series is to present some of the features of the product. If you haven’t tried Database …
Challenge #9 Details If you have been participating for the previous Database Corruption Challenges, you know the routine, but if you are new to the competition you might want to look over some of the previous challenges. This week you are given a corrupt database and you need to remove the corruption without losing any data. This challenge will work …
Welcome to the ninth competition of ten in the Database Corruption Challenge. This week I have created a database and then corrupted one or more parts of that database, and your goal is to fix all of the corruption without losing any data. There is a total of 4 points available this week: One point for being the first person …
After 4 years of beta and 5500 installs of Database Health Monitor beta releases in the last 2 years, Database Health Monitor version 2 is finally complete. It is no longer in beta. If you are curious about the history of Database Health Monitor, take a look at my post from earlier in the week. Here is a preview of …
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 …
Challenge 8 Details You have been assigned to work on a database for another division of your company. It appears that nobody has known about this SQL Server for some time. It may have been corrupt for many weeks or months. You run DBCC CheckDB to discover corruption. There are no backups, other than the backups provided in this challenge. …