Today I released the June 2017 version of Database Health Monitor, you can get it on the download page at http://DatabaseHealth.com.  Here is what it included. Version 2.5.5 Release Notes Version 2.5.5 is the June, 2017 release of Database Health Monitor New Features in 2.5.5 Added a Recovery Model column to the Backup Status Report based on a customer request. …

Database Health Monitor June 2017 Version Released Today Read more »

Today I had the opportunity to release the May 2017 update of Database Health Monitor. This release is version 2.5.4. There are some new cross-instance reports available to allow you to check on your backup and CheckDB work on all of the instances that you are connected to with Database Health Monitor. Version 2.5.4 Release Notes – May, 2017. Version …

Database Health Monitor – May 2017 version released today Read more »

Database Corruption Overview: Database corruption is one of those things that you can only plan for by practicing your response plan. Out of all of the things that can happen to your SQL Server this is the one that you are most likely going to want to ask for help when you encounter it. What is Corruption? Database corruption refers …

Database Corruption Overview for Beginners Read more »

TL;DR summary: Don’t do it. Stop reading here if you want, but just don’t do it. This post refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different conversation, however shrink database does shrink the log file. Not shrinking your database is one of the more counter intuitive …

DBCC ShrinkDatabase – I want to shrink my database. Read more »

With the updated release of Database Health Monitor yesterday, here is the updated list of documentation on the Quick Scan Report.  All of the following (plus a few more) are checked from the Database Health Monitor Quick Scan report. The Quick Scan report checks some common problems that can cause grief on your SQL Server database, and reports on those, …

Database Health Monitor Quick Scan Report Read more »

With over 7500 downloads worldwide to date, I have just released the next installment of the FREE Database Health Monitor application. Here what one person had to say about it “Excellent – It’s the first tool I open every morning to see what is going on in my production environment! Thanks for the great work!” Download today: Database Health Monitor …

Database Health Monitor – Version 2.3 Released Read more »

Today I have the pleasure of releasing the next version of the Database Health Monitor application. Currently at version 2.2, I have been working on this since 2011, and I have introduced some new features in the latest version. Visit the Database Health Monitor Download Page to get it for free today. The main page has been updated, with a …

Database Health Version 2.2 Released Today Read more »

IF you are browsing your error log and come across an error message stating that “1 transactions rolled forward in database ‘msdb’”, or “X transactions rolled back in database ‘msdb’” you might be a bit alarmed. You might also notice similar error messages for master, tempdb or user databases.   How can this be a good thing? Why are transactions …

Transactions Rolled Back in Database Read more »

I have just released version 2.1 of Database Health Monitor, this release involved 2 months of development since version 2.0 was released in July. People often times ask me if this is free, or free to use in production, or free to use on more than one server. The answer is yes indeed, this is a totally free application to …

Database Health Monitor version 2.1 Just Released Read more »