Welcome to another recap of the Stedman SQL Podcast. In Season 2, Episode 26, I discussed one of the most important topics in SQL Server… Read More »Stedman SQL Podcast Sn 2 Ep 26 Backup Types and Retention Periods
A corrupt SQL Server database can be a nightmare scenario for businesses, as it can lead to data loss, operational disruptions, and financial repercussions. Ignoring… Read More »The Consequences of Ignoring a Corrupt SQL Server Database
SQL Server Management Studio (SSMS) is a powerful tool for managing and querying SQL Server databases. One small but incredibly useful feature for developers and… Read More »How to Turn On Line Numbers in SQL Server Management Studio
Can Inserting into a Table with a SELECT from the Same Table Cause Deadlocking? Yes, inserting into a table using a SELECT statement from the… Read More »INSERT INTO SELECT Deadlock
Welcome to an in-depth exploration of database corruption with our expert-led class, “Database Corruption Class By Steve Stedman.” Whether you’re a seasoned database administrator or… Read More »Database Corruption Class By Steve Stedman
We are excited to announce the October 2025 release of Database Health Monitor, version 3.1193.This update builds on the major version 3.0 milestone, delivering another… Read More »October 2025 Release – Database Health Monitor Version 3.1193 | Release Notes
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: XE_SERVICES_MUTEX
In SQL Server, efficient query processing and resource management are crucial for maintaining performance and reliability. One of the often-overlooked components that play a vital… Read More »What is a Worktable – SQL Server
DBCC OPENTRAN is a DBCC command in Microsoft SQL Server that can be used to display information about the oldest active transaction in the database.… Read More »SQL Server DBCC Commands: DBCC OPENTRAN
Quickly Commenting Out Code in SQL Server Management Studio In a recent YouTube video, a helpful tip is shared for SQL Server Management Studio (SSMS)… Read More »Quickly Commenting Out Code in SQL Server Management Studio