SQL Server shut itself down with error 566: an error occurred while writing an audit trace. Here is what the ERRORLOG showed and how to fix it.
SQL SERVER – Error Msg 10778, Level 16 with InMemory OLTP
Can an InMemory table have a foreign key to a disk-based table? I tried it and got Msg 10778. Here is what the error means and the limits to know.
SQL SERVER – Understanding JSON NULL Value Using STRICT Keyword
Why does a JSON path that doesn’t match return NULL? Add the STRICT keyword to get an error instead. A follow-up on JSON NULL values in SQL Server 2016.
SQL SERVER – Script level upgrade for database master failed – Error: 4860, Severity: 16, State: 1 – Cannot bulk load. SqlTraceCollect.dtsx does not exist
SQL Server would not start after patching: script level upgrade for database master failed with error 4860, SqlTraceCollect.dtsx does not exist. The fix.
SQL SERVER – SQL Installation fails with error code 0x851A001A – Wait on the Database Engine recovery handle failed
SQL Server setup failed with 0x851A001A: Wait on the Database Engine recovery handle failed. The ERRORLOG showed error 17120. Here is what caused it.
SQL SERVER – Script level upgrade for database ‘master’ failed – There is already an object named ‘DatabaseMailUserRole’ in the database
After patching, script level Upgrade for master failed: there is already an object named ‘DatabaseMailUserRole’. Here is what caused it and how to fix it.
SQL SERVER – AlwaysOn AG (Availability Group) and TDE Error – Please Create a Master Key
A TDE enabled database would not synchronize in an AlwaysOn availability group, and ERRORLOG said please create a master key. Here is what I found.