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… Read More »Do you need SQL Server Performance Tuning Help?
I just received my email with the PASS Summit 2018 session evaluations, for my presentation on SQL Server Join types. I loved the… Read More »PASS Summit 2018 – My Session Evaluation
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… Read More »Database Corruption Repair Presentation
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… Read More »Find all tables with Change Tracking on your SQL Server
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… Read More »Released Today – Database Health Monitor – November 2018
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… Read More »Find databases running on an older compatibility level
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… Read More »TSQL to find Failed Jobs
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… Read More »SQL Server 2019 Compatibility Level
Today I had the opportunity to present at PASS Summit in Seattle. My presentation was on Friday afternoon in room 6E. This room… Read More »My PASS Summit 2018 Presentation
In preparation for my PASS Summit 2018 presentation on Friday, here is an updated version of the SQL Server JOIN Types poster Try our JOIN… Read More »TSQL JOIN Types Poster