A late-night mail from an old customer about an application error led to this lesson: how to avoid triggers causing trouble with multiple row operations.
SQL SERVER Management Studio – Why I am Seeing White Icon Instead of Green or Red?
SSMS showed a white icon instead of green or red for SQL Server and Agent status, and Start and Stop were disabled. It comes down to your Windows account and WMI.
Creating and Running an SQL Server Unit Test – Best Ways to Test SQL Queries
Testing SQL code matters as much as writing it. I show how to create and run a SQL Server Unit Test with tSQLt, the free open source framework.
SQL SERVER – Database going to Recovery Pending Automatically and Coming Back
A client’s production database kept going into Recovery Pending on its own and coming back. The ERRORLOG showed OS error 32, file in use by another process.
SQL SERVER – Error: 26014, Severity: 16. Unable to Load User Specified Certificate
After a client changed the SQL Server certificate, the service would not start: Error 26014, unable to load User Specified Certificate. Here is how we fixed it.
SQL Server – Understanding Connection Timeouts and Query Timeouts
Understanding connection timeouts and query timeouts in SQL Server: how they differ, why they get confused, and where to look when one hits.
SQL SERVER – Error – Attempted to Perform an Unauthorized Operation
A reader’s SQL Server 2016 setup log showed ‘Attempted to perform an unauthorized operation’ during local discovery. Here is what caused it and the fix.