2025

SQL Server Deadlocks: A Quick Guide Deadlocks in SQL Server occur when two transactions block each other, each waiting for the other’s resources, causing a… Read More »Deadlocks on SQL Server

Monitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or… Read More »Database Health: Monitoring Backups with Database Health Monitor

Today Microsoft released a new update for SQL Server. SQL Server 2022 CU19 for 2022 (16.0.4195.2 – May 2025) CU15 + GDR (16.0.4155.4 – November… Read More »New SQL Update from Microsoft

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding and Resolving High… Read More »Resolving High Virtual Log File (VLF) Count

In the world of database management, ensuring efficient performance of SQL servers is pivotal. One common issue that database administrators face is a slow SQL… Read More »Understanding Slow SQL Server Error Log

DBCC SQLPERF is a database console command (DBCC) in Microsoft SQL Server that can be used to display statistical information about various performance-related aspects of… Read More »SQL Server DBCC Commands: DBCC SQLPERF

Why You Should Add a Clustered Index to Your SQL Server Tables In SQL Server, a clustered index is more than just a performance tweak—it’s… Read More »Tables With No Clustered Index

Managing security within SQL Server is a task that demands precision and careful attention, particularly when dealing with certificates. These digital certificates are crucial for… Read More »Looping Over SQL Server Certificates with Cursors

The CHECK_EXPIRATION option is a security feature of SQL Server that allows you to enforce password expiration for SQL Server logins. When this option is… Read More »Securing SQL Server: CHECK_Expiration for SQL Server logins