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.
When was Domain Account Password Changed in SQL Server? – Interview Question of the Week #093
Error 1069, logon failure, often means the service account password changed in the domain. Here is how to find when a Domain Account Password was last changed.
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.
SQL SERVER – Msg 3047, Level 16, State 1: The BackupDirectory Registry Key is Not Configured Correctly
A backup without a full path suddenly failed with Msg 3047: the BackupDirectory registry key is not configured correctly. Here is why and how I fixed it.
SQL SERVER – Performance Benefit of Using SPARSE Columns?
What is the performance benefit of using SPARSE columns? From a SaaS consulting assignment, here are the considerations I shared with the developers.