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. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …
SQL Server Wait Type: PREEMPTIVE_XE_SESSIONCOMMIT Read more »
Coming up before you know it is our March training webinar! Improve you knowledge and skill set with this FREE Database Health Monitor training and Q&A. This training will be held every month on different days of the week and times so to fit a variety of schedules. Steve will demonstrate tips, tricks and features of this power house tool. …
Database Health Monitor Monthly Training + Q&A for March Read more »
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 can add users to a Windows local group and then create a SQL Server login using that group. The users who are members of the group will then be able to connect to the database …
Securing SQL Server: Windows Local Groups as SQL Logins Read more »
Blocking in SQL Server can occur when….. one query is holding a lock on a particular resource, such as a table or row, and another query is attempting to acquire a conflicting lock on the same resource. This can cause the second query to wait until the first query releases its lock, which can lead to performance issues and, in …
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 data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …
Daily Server Monitoring – SQL Versions for March Read more »
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 from an insert, update or delete statement, and it cause be used for auditing, or tracking of changes. It is also a great way to capture changes for a type of undo mechanism if needed. …
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 corrupt, it requires intervention to repair the damage and restore it to a usable state. The extent of the corruption and the methods used to repair it will determine whether all data can be recovered, …
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. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …
SQL Server Wait Type: HADR_AR_CRITICAL_SECTION_ENTRY Read more »
Save the stress for another day, we have come up with a solution! With our SQL Blocking Query email notification script, you are notified about those blocking queries as they happen giving you time to address the situation. Responding to the blocking before it gets too bad, will reduce those occasions where your SQL Server gets to the point where …
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: This helps ensure that only authorized users can access the SQL Server instance and the data it stores. Encrypting data: Encrypting data can help protec Read more… SQL Server Corruption: What Can Get Corrupted Sun, …