SQL Server Science
Technical Articles for the DBA / Developer
Home » troubleshooting

Connection Pool Exhaustion: Reproducing the Timeout and What SQL Server Sees

2026-11-17 · by Hannah Vernon · in troubleshooting

A PowerShell test that leaks SqlClient connections until the pool times out, what sys.dm_exec_sessions shows, and the fix with proper disposal.

THREADPOOL Waits: Reproducing Worker Thread Exhaustion in SQL Server

2026-11-06 · by Hannah Vernon · in troubleshooting

Reproducing THREADPOOL waits on SQL Server 2019: how max worker threads is sized, what new logins see, and finding the blocker through the DAC.

Reading the SQL Server Error Log Without sysadmin

2026-10-18 · by Hannah Vernon · in security

SQL Server 2022 added VIEW ANY ERROR LOG. I tested the newer permission against sp_readerrorlog and sp_enumerrorlogs.

Proving the Restore, Part 14: Getting the Script Out of the Procedure

2026-09-05 · by Hannah Vernon · in recovery

The generator from builds a restore script into a variable. Getting it back out so someone can read it before running it seems like the easy part. PRINT @script returns the beginning of it. How…

Proving the Restore, Part 13: Two Vocabularies for the Same Backup

2026-09-04 · by Hannah Vernon · in recovery

This series has used two sources for the same information. msdb records what the instance did. RESTORE HEADERONLY reads what’s in the files. They describe the same backups and disagree on almost every name. Code…

Proving the Restore, Part 12: The Files That Take No Extension

2026-09-03 · by Hannah Vernon · in recovery

The restore script generator from worked on most databases and failed on one. The full backup restored fine everywhere else; on this database the restore refused to start. The database had two FILESTREAM filegroups. The…

1 2 3 Next »

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • Data Architecture
  • DMVs
  • documentation
  • extended-events
  • Git for DBAs
  • High Availability
  • Hot Takes
  • Internals
  • maintenance
    • patching
  • Opinion
  • performance
  • PostgreSQL
  • Professional Development
  • recovery
  • reporting
  • ROLLBACK;
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
    • wsus
  • troubleshooting
  • Uncategorized

Pages

  • About Hannah Vernon
  • About SQL Server Science
  • Blog Series
    • Backup & Recovery from First Principles: Series Contents
    • Database as a Versioned Contract: Series Contents
    • Extended Events in Production: Series Contents
    • Git for DBAs: Series Contents
    • How SQL Server Stores Data: Series Contents
    • Logins, SIDs, and Kerberos from First Principles: Series Contents
    • Proving the Restore: Series Contents
    • T-SQL Style Guide, Tested: Series Contents
    • The UNKNOWN Problem: NULL Traps in T-SQL, Series Contents
    • Undocumented Changes in SQL Server 2022 and 2025: Series Contents
    • Work That Flows: Kanban for DBAs: Series Contents
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • Privacy Policy

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2026 SQL Server Science