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

Proving the Restore, Part 9: Backups From a Different Database

2026-08-31 · by Hannah Vernon · in recovery

Two backup files, same database name, same server name, LSNs that line up. They can still be from different databases. Database names get reused. A database is restored under a new name, then renamed back….

Proving the Restore, Part 3: The Error That Blames the Wrong Statement

2026-08-25 · by Hannah Vernon · in recovery

A scheduled job that had run for months started failing after a server was upgraded. The message in the job history: This post is part of the series. The contents page lists every part in…

Mining the system_health Session You Already Have

2026-07-09 · by Hannah Vernon · in extended-events

The system_health session runs by default and writes .xel files. Read the event file, shred the XML, and mine the diagnostics on disk.

A Lightweight Error Audit with Extended Events

2026-07-08 · by Hannah Vernon · in extended-events

Capture error_reported in Extended Events, filter the backup and informational noise at the session, and triage real errors by severity.

Blocked Process Reports: From Capture to Root Cause

2026-07-07 · by Hannah Vernon · in extended-events

Enable the blocked process threshold, capture blocked_process_report in Extended Events, and shred the XML into a blocker and blocked view.

From Deadlock Graph to Repeat Offender: A Production Extended Events Pipeline

2026-07-06 · by Hannah Vernon · in extended-events

Capture xml_deadlock_report in an Extended Events session, persist it past the ring buffer, and rank the repeat-offender procedures in T-SQL.

« Previous 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