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
It is interesting, when working with many different clients, the questions about installing Windows Updates and SQL Server updates comes up and often the discussion… Read More »Latest Service Packs – To Install or Not to Install?
If you are going to PASS Summit 2018, please come and see my Exploring SQL Server JOIN Types presentation on Friday afternoon. Check out our… Read More »Exploring SQL Server JOIN Types