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 André Kamman.
André placed second overall in the the Database Corruption Challenge scoring 22 points which pushed him above a 3 way tie for third place. He was one of only 3 participants to complete all 10 challenges in the contest, the other two were Rob Farley and Neil Abrahams.
Here are the overall statistics for André in the Database Corruption Challenge
André Kamman Interview
What compelled you to want to participate in the Database Corruption Challenge?
I stumbled upon the first week after a tweet from Brent and I was hooked right away.
Or maybe it’s an OCD thing, just wanted to have a 1 on the score board in all those weeks ;-)
What did you find the most interesting in the Database Corruption Challenge?
Learning how to get as much data back as possible while using DBCC Writepage as little as possible.
What did you learn in the Database Corruption Challenge?
Lots, my knowledge about internals, backup and restore, index hints, hack attaching all got a boost. And I loved the whole investigating and making sure I found all the data.
How many weeks did you participate in the Database Corruption Challenge?
All 10 of them
Any suggestions to those who might want to give some of the 10 Database Corruption Challenge examples a try?
Try investigating the data before fixing stuff, you may lose data that you need to solve the puzzle.
These pages are very handy to have open in your browser:
What is your twitter handle, and your linked in url (if you have either)?
Linked In: https://nl.linkedin.com/in/andrekamman
André has also written a blog post titled A FUN WAY TO LEARN ABOUT DATABASE CORRUPTION describing the Database Corruption Challenge.
- Corruption Challenge Winner Interviews: Rob Farley, André Kamman, Raul Gonzalez
- Database Corruption Challenge
- Current Scores
- Newsletter Sign up
- Database Corruption Challenge T-Shirt
- Week 1, Week 2, Week 3, Week 4, Week 5, Week 6, Week 7, Week 8, Week 9, Week 10
- Database Corruption Worksheet