Log File Restore Script
When you do a database restore, including log backups, it is very important to get the log chain in the right order, or it won’t work. To restore a full backup, then log backups, the chain of logs could be …
Year: 2018
Do you need SQL Server Performance Tuning Help?
The team at Stedman Solutions, LLC (Steve, Bill, Derrick, and George) offer a variety of services, but one that I particularly enjoy is the performance tuning work. This usually involves initial contact with a new client who is having performance …
PASS Summit 2018 – My Session Evaluation
I just received my email with the PASS Summit 2018 session evaluations, for my presentation on SQL Server Join types. I loved the feedback, thanks everyone who completed the session evaluations. Something about the Venn diagrams, which …
Database Corruption Repair Presentation
I discovered this recording from a Database corruption repair presentation that I did a few years ago: Related Links Corruption Repair by Stedman Solutions Corruption Challenge
Find all tables with Change Tracking on your SQL Server
Change Tracking is a great feature on SQL Server, but it can have some performance implications. It is however one of those features that doesn’t jump out as obvious if it is enabled until you start digging around on the …
Find all tables with Change Tracking on your SQL Server Read more »
Released Today – Database Health Monitor – November 2018
Today I released the November 2018 (version 2.6.6) release of Database Health Monitor. Version 2.6.6 Release Notes Version 2.6.6 is the November 2018 Release of Database Health Monitor New Features in 2.6.6 Added a check in the Quick Scan report …
Released Today – Database Health Monitor – November 2018 Read more »
Find databases running on an older compatibility level
The SQL Server compatibility level is a SQL Server setting. This is the setting that controls some of the features of how the SQL Server database engine runs, for instance the cardinality estimator. Some people have found problems with certain …
Find databases running on an older compatibility level Read more »
TSQL to find Failed Jobs
It can be frustrating to find recently failed jobs in the job history in SQL Server Management Studio. A quicker way to do it is to just run a query to see what jobs have failed recently. The following …
SQL Server 2019 Compatibility Level
With SQL Server 2019, there is a new compatibility level introduced, level 150 the new SQL Server 2019 Compatibility Level. SQL Server can run in a number of different compatibility levels, but how do you change it and how do …
My PASS Summit 2018 Presentation
Today I had the opportunity to present at PASS Summit in Seattle. My presentation was on Friday afternoon in room 6E. This room was huge, the largest room that I have had a chance to present it at …