Database corruption repair with SQL Server is one of those things that you generally don’t see every day, but as a DBA, you are expected to be able to fix it quickly without any data loss. From the risk analysis matrix, it is one of those low frequency high impact scenarios that results in an extremely risky situation. This is one …
If you are looking for more info on the corrupt database with Week 10 of the Database Corruption Challenge, you can take a look at the week 10 Challenge Details. With this being the final competition of the Database Corruption Challenge, I had to make it more difficult than the others, so I added 3 different types of corruption. This challenge was …
Solution to Week 10 Part 1 Database Corruption Challenge Read more »
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 »
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 Neil Abrahams. Neil placed in third place with a 3 way tie for third overall in the the Database Corruption Challenge scoring 21 …
Neil Abrahams Interview – Database Corruption Challenge Read more »
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 …
André Kamman Interview – Database Corruption Challenge Read more »
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 with Raul Gonzalez. Raul placed third (in a tie) overall in the Database Corruption Challenge behind Rob Farley, and …
Raul Gonzalez Interview – Database Corruption Challenge Read more »
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. Rob Farley is the overall winner, the champion of the Database Corruption Challenge scoring more points than anyone else. Congratulations …
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, it is not too long, so please take a minute or two to provide some feedback. I would really appreciate …
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 »
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 make use of the tree structure to find the rows that you are looking for. However it is not the common …