SteveStedman

Today Microsoft released a new update for SQL Server. SQL Server 2019 CU21 for 2019 (15.0.4316.3 – June 2023) CU18 + GDR (15.0.4280.7 – February… Read More »New SQL Update from Microsoft

There are 2 perspectives here to the DBA on vacation, typically in an organization with only a single DBA so there is no cross coverage… Read More »DBA on Vacation

Hello SQL Server enthusiasts, Throughout my SQL Server journey, I’ve come to appreciate the critical role that data aggregation plays in extracting meaningful insights from… Read More »SQL School: Master the Art of Data Aggregation with SQL Server

Subtitled: the SQL Server password policy query. The CHECK_POLICY option is a security feature in SQL Server that is used to enforce password policy settings… Read More »Securing SQL Server: CHECK_POLICY for SQL Server logins

Foreign keys are a fundamental aspect of relational databases, as they enforce referential integrity between related tables. However, foreign key relationships can also cause performance… Read More »Database Health: Untrusted Foreign Keys

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 DBREINDEX is a has been announced to be deprecated for more than 10 years ago, meaning it may disappear in future versions of SQL… Read More »SQL Server DBCC Commands: DBCC DBREINDEX

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

Database corruption in Microsoft SQL Server can present serious challenges, causing data loss, disruption of services, and potential impact on business operations. Understanding the causes,… Read More »SQL Server Corruption: NOLOCK and Corruption