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… Read More »PASS Summit 2018 – My Session Evaluation
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… Read More »Database Corruption Repair Presentation
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… Read More »Find all tables with Change Tracking on your SQL Server
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… Read More »Released Today – Database Health Monitor – November 2018
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… Read More »Find databases running on an older compatibility level
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… Read More »TSQL to find Failed Jobs
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… Read More »SQL Server 2019 Compatibility Level
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… Read More »My PASS Summit 2018 Presentation
TSQL JOIN Types Poster
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
Latest Service Packs – To Install or Not to Install?
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?