October 2024

Today Microsoft released a new update for SQL Server. SQL Server 2019 CU29 for 2019 (15.0.4405.4 – October 2024) CU28 + GDR (15.0.4395.2 – October… Read More »New SQL Update from Microsoft

The integrity of a Microsoft SQL Server database can be severely undermined by corruption, leading to data inaccessibility and potential operational disasters. Steve Stedman’s comprehensive… Read More »SQL Server Corruption: Stories About Causes of Corruption

SQL Counters: Understanding sys.dm_os_performance_counters in SQL Server Monitoring SQL Server Performance is crucial for ensuring optimal operation. One essential tool for this is the Dynamic… Read More »SQL Counters

The Five Most Popular Features of Database Health Monitor Deadlock Analysis: Automatically captures and analyzes deadlocks, providing clear insights to resolve these conflicts and prevent… Read More »The Five Most Popular Features of Database Health Monitor

The other day I was asked how to use SQL with an IF Statement, so here is my blog post to cover that question. Using… Read More »SQL With IF Statement

Understanding the Difference Between LEFT OUTER JOIN and RIGHT OUTER JOIN in SQL Server When working with SQL Server, one of the fundamental concepts is… Read More »LEFT OUTER JOIN and RIGHT OUTER JOIN

Just 6 days from now our November promotion at Stedman SQL School begins. For the entire month of November, we will be offering some of… Read More »November Promotion at Stedman SQL School

In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes.… Read More »Dangers of Removing Indexes

With years of development into Database Health Monitor, there are many features there for many difference scenarios from performance to security, to overall server health.… Read More »Database Health Monitor with Coaching