MySQL rejected every password with “does not satisfy the current policy requirements”. Here is how to check the validate_password settings and fix it.
SQL SERVER – FIX: Msg 3009, Level 16 – Could not Insert a Backup or Restore History Detail Record in the msdb Database
A slow restore that my client cancelled led to Msg 3009: could not insert a backup or restore history record in msdb. Here is what I learned about a trace flag.
SQL SERVER – Error: Timeout (30000 milliseconds) Waiting for the SQL Server (MSSQLSERVER) Service to Connect
Timeout 30000 milliseconds waiting for the SQL Server service to connect. Why the service start times out, what to check, and how to give it longer.
SQL SERVER – Msg 3168, Level 16 – The Backup of the System Database on the Device Cannot be Restored Because it was Created by a Different Version of the Server
In the recent past, I have written a blog about Ransomware. Here is the link. system database – How to Protect Your Database from Ransomware?
SQL SERVER – Unable to Restore from URL – The Specified URL Points to a Block Blob. Backup and Restore Operations on Block Blobs are not Permitted
Restore from URL failed: operations on block blobs are not permitted. Checked against today’s documentation, the credential decides the blob type.
SQL SERVER – FIX: Msg 15170, Level 16, This login is the Owner of 1 Job(s). You Must Delete or Reassign these Jobs Before the Login can be Dropped
Msg 15170: this login is the owner of 1 job(s) and cannot be dropped. Here is how to find those jobs and reassign them first.
Magic Numbers in Code: Replacing Status Codes With a Lookup Table
Nobody remembers what the 3 means. Give each status code an approved name, let the database enforce it, and leave your data alone.