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.
JSON_MODIFY: Changing One Property Inside a JSON Column
Edit one value inside a JSON document without string surgery. A hands-on tour of the quirks with types, NULL, missing paths and retries.
SQL SERVER – How to Listen on Multiple TCP Ports in SQL Server?
Can SQL Server listen on multiple TCP Ports? Yes, and here are the Configuration Manager steps I shared when a senior DBA asked me during a Health Check.
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.
SQL SERVER – Install Error: Validation for Setting ‘AGTSVCACCOUNT’ Failed. Error Message: The RPC Server is Unavailable
A command-line SQL Server install failed: Validation for setting ‘AGTSVCACCOUNT’ failed, the RPC server is unavailable. I read the setup log and found the fix.
SQL SERVER – Installation Error: The Specified Value ‘Install’ for ACTION is Invalid
A client’s command-line SQL Server install failed with: The specified value ‘Install’ for ACTION is invalid. Here is what the setup log showed and how to fix it.
Backup Error 3636: An Error Occurred While Processing BackupMetadata
Backup error 3636 appeared on a log backup taken on an availability group secondary after a log file was added on the primary. The secondary had not replayed the change. This post shows the queries I use to compare file lists and redo progress, tested on SQL Server 2025.