Error 598 can stop SQL Server from starting right after a patch. In this case the script level upgrade failed because the service account could not create a temporary database file. Giving that account permission on the instance folder let the restart succeed.
SQL SERVER – Could Not Register Service Principal Name Persists – Notes from the Field #105
Seeing ‘Could not register the Service Principal Name’ in your SQL Server log at startup? In Notes from the Field #105, Ryan Adams explains why and what to do.
SQL SERVER – InMemory Table Creation Error Message: Msg 41337
My cousin tried InMemory tables on SQL Server 2016 and hit Msg 41337 while creating one. Here is what the error means and how to get past it.
SQL SERVER – Installation Failed With Error – Wait on the Database Engine Recovery Handle Failed
I ran SQL Server setup on a domain controller by mistake, and the Installation Failed at ‘Wait on the Database Engine recovery handle’. Here is what fixed it.
SQL SERVER – Backup to Azure Blob error – The remote server returned an error: (409) Conflict
My backup to Azure Blob started failing with The remote server returned an error: (409) Conflict. Here is what the ERRORLOG showed and what it means.
SQL SERVER – How to Suppress SQL Server messages in Application Event Log
A brute force attack on sa flooded the Application Event Log with login failures and alerts. Here is how to suppress SQL Server messages from going there.
SQL SERVER – How to take InMemory – OLTP FileGroup Offline?
Can you take an InMemory OLTP filegroup offline, and what happens to the table data? I test it step by step using the database from my earlier post.