Upgrading SQL Server 2008 and R2
Should I upgrade from SQL Server 2008 and SQL Server 2008 R2 now that it is at end of life? On July 9, 2019 SQL… Read More »Upgrading SQL Server 2008 and R2
Database Health Monitor – September Release
Earlier today I had the opportunity to release the September update of Database Health Monitor. This is version 2.91. One of the updates is a… Read More »Database Health Monitor – September Release
Database Health Monitor Usage
Year over year we have had an increase in the number of people regularly using Database Health Monitor as shown in the chart below. I… Read More »Database Health Monitor Usage
SQL Mail Configuration Errors
You may be configuring SQL Mail for the first time or the thousandth time and you come across the following cryptic message. Date 8/xxxxxx03 AM… Read More »SQL Mail Configuration Errors
August Discount on SQL Mentoring
Now through the end of August, at Stedman Solutions, we are offering a discount to the our Prepaid Mentoring package. 20% off the normal rates… Read More »August Discount on SQL Mentoring
Database Health Monitor – August 2019 Release
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… Read More »Database Health Monitor – August 2019 Release
Corruption in TempDB
I received a contact message from the “Contact us” form, asking about how to go about repairing corruption in TempDB. The error message was something… Read More »Corruption in TempDB
TSQL To Start A SQL Agent Job
Most of us are familiar with the quick and easy right clicking on an agent job an select “Start job at Step…”, but what if… Read More »TSQL To Start A SQL Agent Job
Another Successful Database Corruption Repair
At Stedman Solutions, LLC, we recently had the opportunity to help out another client with a corrupt database, to completely recover all their data and remove all the corruption. In this specific scenario Microsoft had told them that their only options was to restore from a backup, but because the corruption had been there for a while before they noticed they didn’t have any recent backups that were corruption free.
In this specific scenario there were 51 tables with corruption, and some other corruption that was in the data file, but not associated with any tables or objects.
Here is how the process went:
Read More »Another Successful Database Corruption Repair
Database Health Monitor 2.8.2 Released
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… Read More »Database Health Monitor 2.8.2 Released