Latch FGCB_ADD_REMOVE timeouts mean a data file is growing slowly. Measured on SQL Server 2025: 4 GB of data in 98 ms, 4 GB of log in 2.3 seconds.
SQL SERVER – Error: 45207 – SQL Server Managed Backup to Microsoft Azure Cannot Configure the Database Because a Container URL was Either not Provided or Invalid
After a cleanup on my Azure SQL VM, I hit Msg 45207: SQL Server Managed Backup to Microsoft Azure cannot configure the database. Here is how I fixed it.
SQL SERVER – Unable to Attach Database Files – The PageAudit Property is Incorrect – Ransomware Attack
After a ransomware attack, a client could not attach database files and saw: The PageAudit property is incorrect. Here is what the error means.
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.
SQL SERVER – Event ID:7034 – MSSQLSERVER Service Terminated Unexpectedly. It has Done this 6 time(s)
Recently, I came across a strange issue. I noticed that the SQL Server service terminates and restarts automatically and doesn’t restart.
How to Find Service Account for SQL Server and SQL Server Agent? – Interview Question of the Week #179
How do you find the Service Account for SQL Server and SQL Server Agent? Here are three ways: Configuration Manager, services.msc, and a T-SQL query.
SQL SERVER – SQL Server Agent Not Starting – Failed to Initialize SQL Agent Log (Reason: Access is Denied).
SQL Server Agent would not start in my lab: Failed to initialize SQL Agent log (reason: Access is denied). Here is what I found in the log folder and the fix.