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
SteveStedman
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?
Exploring SQL Server JOIN Types
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
Database Health Monitor September Release Now Available
Today I have the opportunity to release Database Health monitor version 2.6.5. It has been just a few weeks since the August release, but I… Read More »Database Health Monitor September Release Now Available
CheckDB Error Msg 824 level 24
One of the common CheckDB errors that I see is the Message 824, level 24. This is something that I regularly work to repair for… Read More »CheckDB Error Msg 824 level 24
Running DBCC CheckDB for all of your databases – quick script
Running DBCC CHECKDB DBCC CHECKDB is one of the most essential tools in the SQL Server arsenal, providing a detailed examination of your database’s structural… Read More »Running DBCC CheckDB for all of your databases – quick script
Another Successful Corruption Repair
This week I completed another successful corruption repair. Here is what the client had to say when the database was repaired: Stedman Solutions were… Read More »Another Successful Corruption Repair