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
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