With the recent release of Database Health Monitor Version 2.0 I have decided to focus on of blogging about the features and benefits of the Database Health Monitor application. There are some incredibly valuable features that are often overlooked. The purpose of this blog series is to present some of the features of the product. If you haven’t tried Database …
Challenge #9 Details If you have been participating for the previous Database Corruption Challenges, you know the routine, but if you are new to the competition you might want to look over some of the previous challenges. This week you are given a corrupt database and you need to remove the corruption without losing any data. This challenge will work …
Welcome to the ninth competition of ten in the Database Corruption Challenge. This week I have created a database and then corrupted one or more parts of that database, and your goal is to fix all of the corruption without losing any data. There is a total of 4 points available this week: One point for being the first person …
After 4 years of beta and 5500 installs of Database Health Monitor beta releases in the last 2 years, Database Health Monitor version 2 is finally complete. It is no longer in beta. If you are curious about the history of Database Health Monitor, take a look at my post from earlier in the week. Here is a preview of …
With many participants and 16 who correctly solved Corruption Challenge week 8, the challenge has come to an end. The overall winner was Rob Farley, and there were several new participants this week. The scores page has been updated. Some participants called this the toughest challenge yet which makes my job even harder to come up with something more challenging …
Challenge 8 Details You have been assigned to work on a database for another division of your company. It appears that nobody has known about this SQL Server for some time. It may have been corrupt for many weeks or months. You run DBCC CheckDB to discover corruption. There are no backups, other than the backups provided in this challenge. …
The seventh week of ten in the Database Corruption Challenge went well. There were a few new participants, and many of those who have competed week over week. The first to submit a correct answer this week was Raul Gonzalez. What was interesting about this challenge was that it was not your typical corruption where you could just run DBCC CheckDB and …
Challenge 7 Details On to the Week 7 Corruption Challenge. For this challenge, any version of SQL Server from 2005 or newer will work, however I don’t know on Azure, and I haven’t tried it on SQL Server 2016 CTP2 yet. I did test it on SQL Server 2005 and on SQL Server 2014. Not all missing data is caused …
Welcome to the seventh week of 10 in the Database Corruption Challenge (DBCC), this is an about weekly competition. Here is how it works; I have created a corrupt database, hopefully more corrupt or more interesting than the previous week. I then solved the corruption myself in order to prove that it is possible to fix, without data loss. New …
Welcome to the seventh week of 10 in the Database Corruption Challenge (DBCC), this is an about weekly competition. Here is how it works; I have created a corrupt database, hopefully more corrupt or more interesting than the previous week. I then solved the corruption myself in order to prove that it is possible to fix, without data loss. New …