Your Query Store may want READ_WRITE and still be READ_ONLY. Here is how it happens, how to read the reason, and how to get capture back.
SQL SERVER – Database Attach Failure – Msg 2571 – User ‘guest’ Does Not Have Permission to Run DBCC Checkprimaryfile.
Attaching MDF and LDF files after a disaster failed with Msg 2571: user guest does not have permission to run DBCC checkprimaryfile. Here is the fix.
SQL SERVER – Puzzle – How Does YEAR Function Work?
SELECT YEAR(35000/20) returns 1904, which looks strange. This puzzle shows how the YEAR function treats a plain integer. Can you explain the result?
Salted Password Hashes With HASHBYTES and CRYPT_GEN_RANDOM
A salt makes two identical passwords look different, yet it does not slow down guessing. Here is a small demo of both, and what to use instead.
SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (404) Not Found
Error 3271 during backup to URL has many causes. After the 403 and 400 versions, here is what causes the (404) Not Found error and how to fix it.
What is Alternative to CASE Statement in SQL Server? – IIF Function – Interview Question of the Week #164
What is the alternative to CASE statement in SQL Server? The IIF function. Here are two examples of CASE and IIF, and why IIF deserves more use.
SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (403) Forbidden
A reader’s backup to URL failed with Error 3271: the remote server returned an error: (403) Forbidden. Here is how I reproduced it and the easy fix.