Although clustered indexes are not required, and there are many cases where you should not use a clustered index, quite often clustered indexes can be overlooked when creating a table. This is actually more likely if you are inheriting a …
Finding tables that don’t have a clustered index. Read more »
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 …
Today I have released beta 9 of the Database Health Monitor. It has been 27 months since the release of Database Health Beta 1, and almost 4 years since the original SSRS implementation of Database Health reports. To be honest …
Today I presented on Advanced CTEs at SQL Saturday Denver. Here are my slides and sample code for download: Advanced CTEs Denver Thanks to everyone who attended, I hope you enjoyed the presentation. Don’t forget to try out the Database …
One of the ideas behind Scrum software development is the idea of “Release early, Release Often and Get Customer Feedback.” After the release of Beta 7 of the Database Health Reports earlier this week I received an email with a …
As I get ready for Beta 7 to launch I have decided that for Beta 8 I will focus on feature suggestions from the users of the Database Health application. I have created a feedback system for users to suggest their …
As Beta 7 of the Database Health Reports approaches is just three weeks, the big new feature that has been added is the SQL Technical Debt Analysis. The SQL Technical Debt Analysis a great check for those areas that are …
Today marks the 1000th download of the Database Health Reports in the last 11 months since Beta 1 was released. I thought this would be the perfect opportunity to recap on the history of the database health report application. First …
One Thousandth Download of Database Health Reports Read more »
As part of my contribution back to the SQL Server community I am adding a new feature into the free Database Health Reports application. I am currently working on adding a new feature into the Database Health Reports to analyze T-SQL Technical Debt. If …
Working on the T-SQL Technical Debt feature in the Database Health Reports Read more »
I received this rave today about the Database Health Reports. It has been posted on the Raving Fans page. 7/17/2013 – Beta 6 Rave The software is really good, I am using very regularly to audit and performance tune the …