Build a small audit trigger that joins inserted and deleted, handles NULL changes correctly and ignores saves that change nothing.
SQL SERVER – Event ID: 2004 – Resource Exhaustion Diagnosis Events
A client with SQL Server memory issues saw Event ID 2004, Resource Exhaustion Diagnosis Events, naming sqlservr.exe for low virtual memory. Here is what it means.
How to Change Language for SSMS? – Interview Question of the Week #194
How do you change language for SSMS? A workshop attendee asked me and I had to research it, but the steps are simple and start in the Tools menu.
SQL SERVER – Event ID: 10028 – SQL Server Distributed Replay Client – DCOM was Unable to Communicate with the Computer
Event ID 10028 from the SQL Server Distributed Replay Client flooded a client’s event log and buried the data we needed. Here is how to stop the noise.
SQL SERVER – SSIS – Package Error: “ODBC Source” Failed Validation and Returned Validation Status “VS_NEEDSNEWMETADATA”
A client’s SSIS package failed: “ODBC Source” failed validation and returned validation status “VS_NEEDSNEWMETADATA”. I explain which metadata and the fix.
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 – SQL Server Configuration Manager Error: 0x80010108 – The Object Invoked Has Disconnected From its Clients
SQL Server Configuration Manager gave error 0x80010108: The object invoked has disconnected from its clients. Here is one cause I could reproduce on demand.