The log shipping monitor stopped updating last_backup_file and last_backup_date for the primary, while every job ran fine. Here is how I traced it.
SQL SERVER – Error: 17142 – SQL Server Service has Been Paused. No New Connections Will be Allowed
What happens when you pause the SQL Server service? Error 17142 appears and no new connections are allowed, while existing users keep working. Here is the fix.
SQL SERVER – Slow Filestream Data Cleanup. What Should We Do?
Slow Filestream Data Cleanup can follow deletion when files are still ineligible for garbage collection. One customer was running out of space.
SQL SERVER – Historical SSMS Vulnerability Assessment and Current Availability
SQL Vulnerability Assessment was available in older SSMS releases. My walkthrough used SSMS 17.4 with SQL Server 2012 or later.
Restart Azure SQL Database: What Works and What Doesn’t
You can’t restart Azure SQL Database the way you restart SQL Server, because Microsoft runs the service. This post shows what to do instead: find and end the blocking session, scale the database, or trigger a failover. It tests the blocking query on a demo database and explains why a stack dump is not a restart.
SQL SERVER – Account Added Automatically in SQL Server Used by SharePoint
A departed user’s account kept being added automatically to SharePoint database roles. How to catch who adds it, and from where, on SQL Server 2025.
SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use
Mapping a share with net use through xp_cmdshell, I hit “The local device name is already in use”. Here is what causes this error and how to solve it.