Joining a database to an availability group failed with Msg 35250: the connection to the Primary Replica is not active. Here is why and how to fix it.
My Journey to CrossFit Level 2 Trainer (CF-L2) Credential – Level Up
Fitness is a journey, not a destination. I just earned my CrossFit Level 2 Trainer (CF-L2) credential, and here is my journey to this milestone.
SQL SERVER – Ransomware Protection and Recoverable Offline Backups
Ransomware recovery depends on protected backups and controlled access. I test whether those recovery copies survive the loss of normal systems.
SQL SERVER – Why We have Audit Trace in DATA Folder? What are These Files?
The DATA drive filled up with thousands of audittrace .trc files. Here is why SQL Server writes audit trace files there and how to stop them.
What is the Difference Between Physical and Logical Operation in SQL Server Execution Plan? – Interview Question of the Week #122
Question: What is the Difference Between Physical and Logical Operation in SQL Server Execution Plan?
Msg 15153: xp_cmdshell Proxy Account Cannot Be Retrieved
Msg 15153 is the second error a non-sysadmin user hits when running xp_cmdshell. A retail team with about 1,500 databases saw it right after Msg 229. A proxy account plus an EXECUTE grant fixed it.
Visual Studio 2010 Shell Error During SQL Server Patching: Missing Package
A Visual Studio 2010 Shell error interrupted a SQL Server patch in a 2017 case. The setup screen named the component, but the component log named the missing package. This post shows how to read the logs, decode the Windows Installer error and match the package before any repair.