June 2023

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

Keeping your SQL Server up-to-date with the latest patches and updates is an important part of maintaining the security and stability of your system. Here… Read More »Securing SQL Server: Patching your SQL Server

DBCC TRACESTATUS is a database console command (DBCC) in Microsoft SQL Server that can be used to display the status of a trace flag, which… Read More »SQL Server DBCC Commands: DBCC TRACESTATUS

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