Lately several people have asked me for the solutions to the corruption challenge, so I thought it would be a good time to recap the last 5 weeks. Week 1 of the Database Corruption Challenge was won by Brent Ozar, …
Hello everyone, the last week I have not been able to keep everyone as up to date on the Database Corruption Challenge as I would like to. Life has just turned really busy in the last 10 days, but I …
Here is how I solved Week 5 of the Database Corruption Challenge. The following steps were tested and confirmed working on SQL Server 2008R2, SQL Server 2012, and SQL Server 2014. To oversimplify, here are the steps: Restore the …
Find out more about the Week 5 Challenge on the overview blog post. The winning solution, was submitted by Patrick Flynn, just 3 hours and 18 minutes after the challenge was posted. Patrick provided me with the following steps, and TSQL …
Week 5 – Winning Solution – Database Corruption Challenge Read more »
Today I had the opportunity to present When Corruption Strikes to the PASS DBA Virtual Chapter Meeting. This was a lot of fun to be able to recap the previous 4 weeks of the Database Corruption Challenge, and share some of the …
Welcome to the Week 5 Corruption Challenge. If you have seen the t-shirt that I designed for the winner at the end of the 10 week period, please take a look. We are currently at the 5 week midpoint of …
There is a lot happening right now, so I thought I would put together a brief overview of upcoming speaking engagements. May 13th – When Corruption Strikes (PASS DBA Virtual Chapter Meeting) May 16th – Exploring SQL Server Join Types – …
On Wednesday May 13th I will be presenting to the PASS DBA Virtual Chapter Meeting, at Noon Mountain time (convert to your time zone). The session is titled “When Database Corruption Strikes“, and the event has been sponsored by Dell Software …
When Corruption Strikes – Online Presentation Wed May 13th Read more »
Database Corruption Challenge #5 is coming soon. Those who subscribe to my newsletter will know the exact date and time of the next Database Corruption Challenge. Lets take a look back at the winners from the previous challenges. Week 1 …
The following is a solution to Corruption Challenge #4 that uses DBCC WritePage to fix the corruption. Before proceeding, be sure to read this warning. WARNING: DBCC WritePage is a dangerous command, that should never be used on any production …
Corruption Challenge 4 – Second Alternate Solution. Read more »