June 2024

Today Microsoft released a new update for SQL Server. SQL Server 2019 CU27 for 2019 (15.0.4375.4 – June 2024) CU25 + GDR (15.0.4360.2 – April… Read More »New SQL Update from Microsoft

Managing a SQL Server environment can be a daunting task, especially for businesses without a dedicated DBA team. SQL Server issues can lead to significant… Read More »Why Your SQL Server Needs Expert Managed Services

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

Top 4 SQL Server Performance Tuning Mistakes and How Stedman Solutions Can Help 1. Ignoring Index Fragmentation Mistake: Over time, indexes become fragmented, leading to… Read More »Top 4 SQL Server Performance Tuning Mistakes

Today Microsoft released a new update for SQL Server. SQL Server 2008 None 2024-06-07 Here are the latest updates for each version of SQL Server.… Read More »New SQL Update from Microsoft

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 June

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

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