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
Largest tables on an instance
Here is a quick script that I find myself using frequently to find the largest tables on an entire SQL Server instance.
TSQL Formatting and Wild Card Expansion
For years I have struggled to find a good way to do TSQL formatting. Here is a short video of how to simple TSQL cleanup… Read More »TSQL Formatting and Wild Card Expansion
SQL 2016 Won’t Send Mail
One of the more challenging components to configure on SQL Server is SQL Mail. I don’t know how many times I have had to try… Read More »SQL 2016 Won’t Send Mail