Patrick Flynn Interview – Database Corruption Challenge

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 points.

Here are the overall statistics for Patrick in the Database Corruption Challenge

• Overall Rank: #3 (3 way tie)
• Points Scored: 21
• Number of Challenges First to Solve (winning): 1
• Number of Challenges Solved: 9
• Country: Australia

Patrick Flynn Interview

What compelled you to want to participate in the Database Corruption Challenge?

Patrick: I came across the Database Corruption Challenge while I was stuck at home recovering from badly injuring my foot. I initially began participating to help pass time while I was recovering but then got interested in the opportunity to learn more about internals of SQL Server.

What did you find the most interesting in the Database Corruption Challenge?

Patrick: The opportunity to do a deep dive into the internal structures of SQL Server. Also seeing some of the alternative approaches used

What did you learn in the Database Corruption Challenge?

Patrick: I gained a much greater understanding of DBCC PAGE, DBCC WRITEPAGE and even DBCC CHECKDB

How many weeks did you participate in the Database Corruption Challenge?

Patrick: I participated in final nine challenges. I could solve Challenge 1 but did not find it until after the closing date

Any suggestions to those who might want to give some of the 10 Database Corruption Challenge examples a try?

Patrick: Read the Blogs / Watch presentations from Paul Randal

What is your twitter handle, and your linked in url (if you have either)?

Patrick: Twitter: @sqllensman

Related Links

• Corruption Challenge Winner Interviews: Rob Farley, André Kamman, Raul Gonzalez, Neil Abrahams, Patrick Flynn
• 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

Database Corruption Challenge Sponsored by Stedman Solutions, LLC.

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!