It is my pleasure to announce the winners in the Week 3 Database Corruption Challenge. But first how about a rundown of challenge.
The challenge was issued at 10:00pm (pacific time) on Friday night. Yes, this was a difficult time for those on the East coast of the US, and if you are from EST, next week I promise the time will be better for you. Trying to switch up the times to give everyone across the planet a fair advantage. Those who had signed up for my Newsletter received early notification of when the corruption challenge would occur, but not details on what the challenge would be.
Once the challenge was issued, I received a couple of partial submissions, one contained the correct steps, but no results. The second one contained the right results, but was missing the steps to do it. The first correct submission that contained the steps, and proof that it was done correctly came in 37 minutes after the contest had started. It was almost an hour later before the next winning solution was sent in.
The winner this week was Randolph West, his solution is posted as a separate post here. This was Randolph’s first time competing in the Corruption Challenge, and he took the victory for this week.
Over the weekend several winning solutions continued to come in. Overall there were 29 winning solutions submitted this week, this largest number of any of the corruption challenges so far.
Current Scoring
If you noticed by post last week describing the updated scoring plan, here are the current results.
| Name | Week1 | Week2 | Week3 | Link To Site | Total |
| Rob Farley | 1 | 2 | 1 | 4 | |
| André Kamman | 1 | 1 | 1 | 3 | |
| Bogdan Sahlean | 1 | 1 | 1 | 3 | |
| Ivan Rodriguez Camejo | 1 | 1 | 1 | 3 | |
| Neil Abrahams | 1 | 1 | 1 | 3 | |
| Nicolette Carpenter Boddie | 1 | 1 | 1 | 3 | |
| Pasquale Ceglie | 1 | 1 | 1 | 3 | |
| Rui Bastos | 1 | 1 | 1 | 3 | |
| Subhro Saha | 1 | 1 | 1 | 3 | |
| Arthur Baan | 1 | 1 | 2 | ||
| Brent Ozar | 2 | 2 | |||
| David Patterson | 1 | 1 | 2 | ||
| John Sterrett | 1 | 1 | 2 | ||
| Jon Gurgul | 1 | 1 | 2 | ||
| Lucas Kartawidjaja | 1 | 1 | 2 | ||
| Michel Bruggeman | 1 | 1 | 2 | ||
| Parikshit Savjani | 1 | 1 | 2 | ||
| Patrick Flynn | 1 | 1 | 2 | ||
| Prageet Surheley | 1 | 1 | 2 | ||
| Randolph West | 2 | 2 | |||
| Sébastien Piché | 1 | 1 | 2 | ||
| André Abiscula Guimarães | 1 | 1 | |||
| Andrew Pruski | 1 | 1 | |||
| Damian Widera | 1 | 1 | |||
| Dan Brennan | 1 | 1 | |||
| Dave Walden | 1 | 1 | |||
| Henrik Bo Hansen | 1 | 1 | |||
| Herman Atmadja | 1 | 1 | |||
| John Morehouse | 1 | 1 | |||
| Kumar Muppa | 1 | 1 | |||
| Michael Docherty | 1 | 1 | |||
| Mohan Baba | 1 | 1 | |||
| Patrick Keisler | 1 | 1 | |||
| Pedro Ferreira | 1 | 1 | |||
| Piche Sebastien | 1 | 1 | |||
| Raul Gonzalez | 1 | 1 | |||
| Robin Watkins | 1 | 1 | |||
| Seann Alexander | 1 | 1 | |||
| Shashikant Shakya | 1 | 1 | |||
| Shawn Johnson | 1 | 1 | |||
| Walden H. Leverich | 1 | 1 | |||
| wBob | 1 | 1 |
Here is a summary of the scoring criteria.
- Each week you can earn the following points:
- 2 points for being the first to submit a correct solution, as long as you mention the contest on twitter, with a link.
- 1 point for submitting a correct solution before the deadline
- Once in the competition you can earn points for the following:
- 1 point for creating a blog post that talks about the challenge, and links to http://SteveStedman.com/corruption (if you do this you should email a link to the post).
So far there has been only one person who earned a point by linking to the Corruption Challenge
Related Links
- Overall Scores
- Week 3 Corruption Challenge
- Week 3 Winning Solution
- Database Corruption Challenge (previous weeks)
- Newsletter Signup
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!