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 »

As a DBA you regularly schedule backups you might have regular full backups, incremental backups and hopefully regular backups. Over time you might realize that your error log is not longer filled with errors, but instead a majority of your …

Quick Scan Report – Logs Flooded with Backup Messages Read more »

Today I released the August 2019 release of Database Health Monitor. This is version 2.9. My favorite new report is the Blocking By Hour of Day report which uses the existing data that is collected by the historic monitoring feature. …

Database Health Monitor – August 2019 Release Read more »

Yesterday I released the first update to Database Health Monitor in a couple of months. There were some new features and some fixed saved up that were released yesterday. I did however run into 2 small bugs that were quickly …

Database Health Monitor 2.8.2 Released Read more »