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 and formatting using just SQL Server Management Studio (SSMS). This works on SSMS from SQL Server 2005, all the way up to the latest release of SQL Server Management Studio. It is not as nice …
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 it multiple times before getting it right. Here is an article written by Derrick, one of the Stedman Solutions team on problems with SQL Server 2016 being able to send email. Written by Derrick Bovenkamp: …
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 the functionality of the SQL Server transaction log is not entirely clear. The way that backups and the log file work is that the log file is made up of internal virtual log files (VLFs). …
Why is my log file not shrinking when I do regular backups? Read more »
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 this mean? No more updates, no more security patches, and no more support. It is strongly recommended that prior to end of life that you move to an updated supported version of SQL Server, so …
SQL Server 2008 and 2008R2 End of Life – coming soon Read more »
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 of the most valuable features in Database Health Monitor. You can use it to see how thing are changing over time on your system. You can even answer questions like “The server was running slow …
Database Health Monitor – Historic Wait Monitoring Read more »
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 the session, the Basics of Database Corruption Repair. Duration: 60 minutesTrack: AdminLevel: Intermediate Your database is running fine month after month with no problems. Suddenly someone reports that their query won’t run. They get an …
Today I am happy to release version 2.7 of the Database Health Monitor today. You can download the latest version here.
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 release. More information from Microsoft.
In the consulting world we come across many different backup and restore options for SQL Server with the different clients that we work with. Personally I am a big fan of the SQL Server backups using a combination of Full, Differential, and Log backups so that we can do a solid point in time restore when needed. I also like …
Do you need help with a slow running SQL Server? Take a look at these SQL Server performance tuning options that we offer. Stedman Solutions Performance Tuning