Unlocking the Power of Common Table Expressions (CTEs) in SQL Server Common Table Expressions (CTEs) are one of SQL Server’s most versatile tools, transforming the… Read More »Common Table Expressions (CTEs) in SQL Server

If you are reading this article becuase you are trying to repair your corruptin database, please reach out ot us at Stedman Solutions we can… Read More »SQL Server Corruption: More about Detecting Corruption

Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database.… Read More »SQL Server Wait Type: LCK_M_SCH_S

The SA (System Administrator) account is a predefined account in SQL Server that has full control over the database server. By default, the SA account… Read More »Securing SQL Server: Renaming and Disabling the SA Account

What is Wait Stats Monitoring in SQL Server? For more information on Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial… Read More »Wait Statistics Monitoring

Today Microsoft released a new update for SQL Server. SQL Server 2022 CU18 for 2022 (16.0.4185.3 – March 2025) CU15 + GDR (16.0.4155.4 – November… Read More »New SQL Update from Microsoft

How Often Should You Run CHECKDB on SQL Server? If you’re a database administrator or a developer working with Microsoft SQL Server, you’ve likely heard… Read More »How Often Should I Run CheckDB

Stedman SQL Podcast: Unveiling the New Schema Drift This week on the Stedman SQL Podcast, Steve Stedman takes us through an exciting deep dive into… Read More »SchemaDrift featured on Stedman SQL Podcast

Five Fantastic Ways to Master SQL Server Join Types Hey there, SQL enthusiasts and database professionals! It’s Steve Stedman from Stedman Solutions, LLC. Today, I’m… Read More »Five Fantastic Ways to Master SQL Server Join Types