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
SteveStedman
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
Database Health Monitor – Historic Wait Monitoring
What kind of load does the historic monitoring put on the SQL Server? It is my opinion that the historic wait monitoring is perhaps one… Read More »Database Health Monitor – Historic Wait Monitoring
Basics of Database Corruption Repair
Please join me on Saturday March 16 in Victoria BC Canada for my SQL Saturday presentation on the Basics of Database Corruption Repair. Here is… Read More »Basics of Database Corruption Repair
Database Health Monitor Version 2.7 Released Today
Today I am happy to release version 2.7 of the Database Health Monitor today. You can download the latest version here.
SQL Server 2019 community technology preview 2.3
As SQL Server 2019 approaches its release to manufacturing date, we get another update, Community Technology Preview 2.3. This puts it one step closer to… Read More »SQL Server 2019 community technology preview 2.3