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
SteveStedman
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
Why is my log file not shrinking when I do regular backups?
I often times get the question similar to “Why is my log file not shrinking when I do regular backups”? It goes to show there… Read More »Why is my log file not shrinking when I do regular backups?
SQL Server 2008 and 2008R2 End of Life – coming soon
Microsoft has announced that as of July 2019 SQL Server 2008 and SQL Server 2008R2 will be at the end of life support. What does… Read More »SQL Server 2008 and 2008R2 End of Life – coming soon