Tag: connections

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

How to Kill All Connections to a SQL Server Database: Script and Best Practices
9 Oct 2026 · 7 min read

How to Kill All Connections to a SQL Server Database: Script and Best Practices

Use a two-line T-SQL script to kill all SQL Server database connections instantly - no restarts, no cursors, no outdated forum hacks.

Read article →
How to Kill All SQL Server Database Connections
15 May 2018 · 7 min read

How to Kill All SQL Server Database Connections

Clear all active SQL Server connections fast using SINGLE_USER mode or a scripted kill loop. Covers when to use each method and what to watch out for.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.