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

Securing SQL Server: Basic Security Measures Tue, 28 Feb 2023 There are several ways that you can secure SQL Server, including: Enabling authentication and authorization:… Read More »February Blog Post Wrap-up

There are several ways that you can secure SQL Server, including: Enabling authentication and authorization: This helps ensure that only authorized users can access the… Read More »Securing SQL Server: Basic Security Measures

In a Microsoft SQL Server database, several components can become corrupt, including: * Data pages: Data pages store the actual data in a SQL Server… Read More »SQL Server Corruption: What Can Get Corrupted

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

The Hide Instance option in SQL Server allows you to hide a specific instance of SQL Server from the list of available instances on the… Read More »Securing SQL Server: Hide Instance Server Setting