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

Here is a short video on managing VLFs on SQL Server https://youtu.be/VjsgTWkws8M?si=ywngDBtdL9uE2i0X Best Practices for Managing VLFs (Virtual Log Files) in SQL Server One of… Read More »What are VLFs and why should you care

DBCC CHECKALLOC is a database console command (DBCC) in Microsoft SQL Server that can be used to check the allocation and structural integrity of the… Read More »SQL Server DBCC Commands: DBCC CHECKALLOC

Ensuring Security in Database Health Monitor: How We Use Snyk for Weekly Vulnerability Analysis At Stedman Solutions, we prioritize the security and integrity of our… Read More »Ensuring Security in Database Health Monitor