Just about 24 hours after releasing Database Corruption Challenge #9, so far there have been 15 winning solutions. The first to submit a winning solution was Eduardo Rezende. The scores have been updated. Rob Farley is back in the lead with 18 points, second place is Raul Gonzalez with 17 points, followed closely by Neil Abrahams, André Kamman, and Patrick Flynn with …
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 …
Almost a month ago Brent Ozar did a blog interview with me regarding the Database Corruption Challenge so I thought I would return the gesture and do the same for him. I ended up going to the Bellingham SQL Server Users Group (PASS Chapter) to build the list of questions. The members of the group helped build the questions, and here …
Over the last 4 years I have been working on the Database Health Monitor. I am about a week away from releasing Version 2, which will finally be out of the beta process. In preparation for the release I am sharing some of the history of this program. In 2011 version 1 was released as a set of my favorite …
The speaker lineup for PASS SUMMIT 2015 was announced today and my Advanced Common Table Expressions session was accepted. Here is the abstract: You might have been introduced to Common Table Expressions (CTEs) and understand the WITH syntax, but want to know more. Learn how recursive queries work with CTEs and how to display hierarchical data. Did you know …
I will be presenting at PASS Summit 2015 in October Read more »
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 …
During my 24 Hours of Pass presentation on Advanced CTE’s today I was asked the question about deleting from a CTE when it uses an EXISTS statement that queries another table. I figured I would create quick blog post to show the example. First some background when using the delete statement with a CTE you can’t delete if the query inside …
Today I am presenting on Advanced Common Table Expressions as part of the 24 Hours of PASS conference. It is being webcast so check it out if you can. The outline for the presentation will be the following: Recursive Queries Hierarchical Recursive Data Manipulating Data Common Use Cases CTE Performance Considerations Classic Recursive Algorithms The sample code and slides are …
Several participants have stated that week 8 is the most difficult week yet. However it is possible to recover all of the corrupt data. For anyone having difficult with Database Corruption Challenge week 8, I have added an extra clue. Click through on Database Corruption Challenge #8 and page down to the extra clue section. You can still try to …
Extra clue added for Database Corruption Challenge Week 8 Read more »