SteveStedman

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

Today Microsoft released a new update for SQL Server. SQL Server 2017 CU31 for 2017 (14.0.3456.2 – September 2022) CU31 + GDR (14.0.3485.1 – November… Read More »New SQL Update from Microsoft

4 Essential Checks for Diagnosing a Slow SQL Server A slow SQL Server can disrupt applications, frustrate users, and impact business operations. Diagnosing the cause… Read More »Essential Checks for Diagnosing a Slow SQL Server