Error 9002 has many causes. Here I explain the one where the transaction log for database ‘SQLDB’ is full due to ‘DATABASE_MIRRORING’ and what it tells you.
ROWLOCK Hint and Slow Performance in SQL Server
A ROWLOCK hint makes SQL Server lock each row it reads instead of whole pages. This post counts the locks of the same scan with and without the hint, times both versions, shows how an open transaction on a busy server changes the result, and explains how ROWLOCK differs from UPDLOCK.
Startup Stored Procedures in SQL Server: Uses and Risks
Startup stored procedures run every time SQL Server starts, which makes them useful and easy to forget. This post covers good uses, the risks, a wait that gives up instead of looping forever, and how to list and remove the startup stored procedures already on a server. The setup steps are in a separate post.
How Old Version of SQL Server Running on Server? – Interview Question of the Week #183
Is your server on an old version of SQL Server? Run SELECT @@VERSION to see the build and the date the patch was created, a check I often run during a Health Check.
SQL SERVER – Backup to URL – Script to Perform Striped Backup using Shared Access Signature (SAS)
A reader wanted a striped backup to Azure Blob Storage. Here is my script to take a striped Backup to URL across several files using a SAS token credential.
SQL SERVER – Backup to URL – Script to Generate Credential and Backup using Shared Access Signature (SAS)
Backup to URL can connect to Azure storage with a SAS token. I share a script that generates the credential and the backup command using a Shared Access Signature.
SQL SERVER – Msg 3292: A Failure Occurred While Attempting to Execute Backup or Restore With a URL Device Specified
My client’s backup to Azure failed with Msg 3292: a failure occurred while attempting to execute Backup or Restore with a URL device. Let me show you the fix.