SteveStedman

Understanding and Resolving SQL Server Error 18456: Login Failed for User SQL Server Error 18456 is a common login error that can cause headaches for… Read More »SQL Server Error 18456: Login Failed

Understanding the Top 10 Most Common Wait Types in SQL Server When managing SQL Server Performance, understanding wait types is crucial for diagnosing and troubleshooting… Read More »10 Most Common Wait Types

Today Microsoft released a new update for SQL Server. SQL Server 2019 CU30 for 2019 (15.0.4415.2 – December 2024) CU29 + GDR (15.0.4410.1 – November… Read More »New SQL Update from Microsoft

Why Duplicate Indexes Are Bad in SQL Server Indexes are one of the most powerful tools in SQL Server for improving query performance. However, like… Read More »Database Health Monitor: Duplicate Indexes

DBCC WRITEPAGE is an undocumented and unsuported DBCC command in Microsoft SQL Server that can be used to write a page of data from a… Read More »SQL Server DBCC Commands: DBCC WRITEPAGE

Understanding the Anti Left Join in SQL Server An anti left join, also known as a left join with exclusion, is a query pattern used… Read More »SQL School: ANTI LEFT JOIN

Why Database Health Monitor is Essential for DBAs As a database administrator, having a reliable, efficient monitoring tool is essential to ensure your database remains… Read More »Database Health Monitor: Insight Into Database Performance

Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the… Read More »Daily Server Monitoring – SQL Versions for December

Hello there! My name is Steve Stedman, and I want to tell you about an amazing product from Stedman Solutions, the Database Health Monitor. As… Read More »Database Health Monitor – Free Download