1. What is the SA account in SQL Server? The SA (System Administrator) account is the default administrative account in SQL Server, granting unrestricted access to the entire SQL Server instance. It has full permissions to perform any action on …
FAQ: Why You Shouldn’t Use the System Admin Account SA on Microsoft SQL Server Read more »
What is Remote Query Timeout? For the pupose of this article we will abbreviate Remote Query Timeout as RQT. RQT is a setting in SQL Server that specifies the maximum amount of time a remote query can run before timing …
Introduction With the release of SQL Server 2019 CU 27, some users have encountered a bug that causes the error log to be flooded with the following warning message: source This issue results from an incorrect code change during the …
SQL Server 2019 CU 27 Bug: “WARNING Long asynchronous API Call” Error Log Flooding Read more »
Why is low disk space a concern for SQL Server? Low disk space can cause several issues in SQL Server, including: What immediate steps can I take to free up disk space? How can I prevent low disk space issues …
What are Database Snapshots? A Database Snapshot is a read-only, static view of a SQL Server database (the source database) at a particular point in time. It allows you to quickly create a version of your database that you can …
User-defined assemblies (UDAs) in SQL Server provide a powerful way to extend the capabilities of your database. However, they also introduce potential issues and security risks that must be carefully managed. This help page aims to elucidate why UDAs can …
Understanding the Risks of User-Defined Assemblies in SQL Server Read more »
UPDLOCK Hint in SQL Queries: Reasons to Avoid and Best Practices The UPDLOCK hint in SQL Server is used to indicate that the lock obtained on the selected rows is to be held until the end of the transaction. This …