DBCC CHECKALLOC is a database console command (DBCC) in Microsoft SQL Server that can be used to check the allocation and structural integrity of the… Read More »SQL Server DBCC Commands: DBCC CHECKALLOC

Monitoring long-running queries is an essential part of database performance monitoring, as it can help identify queries that are causing performance issues and take corrective… Read More »Monitoring Long-running Queries

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_XE_SESSIONCOMMIT

In SQL Server, you can create logins using Windows local groups as a way to manage access to the database server. This means that you… Read More »Securing SQL Server: Windows Local Groups as SQL Logins

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 March

Have you seen our SQL short course on the TSQL Output Clause? The SQL Server output clause is a great way to get data back… Read More »TSQL Output Clause Course

Will a corrupt SQL Server database ever just get better? No, a corrupt SQL Server database will not just “get better.” Once a database is… Read More »SQL Server Corruption: Will It Get Better

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