SQL Server Science
Technical Articles for the DBA / Developer
Home » t-sql

Documenting ETL Procedure Data Flow from SQL Server Metadata

2026-11-13 · by Hannah Vernon · in t-sql

Which tables does each ETL procedure read and write? Testing sys.dm_sql_referenced_entities on SQL Server 2019 and 2025, and where its answers go wrong.

What a Linked Server Query Sends: Four-Part Names, OPENQUERY and EXEC AT

2026-11-09 · by Hannah Vernon · in t-sql

Which filters and joins reach the remote server in a linked server query? I traced four-part names, OPENQUERY and EXEC AT, and counted the rows.

Trigger Archaeology: Mapping Nested and Recursive Trigger Chains

2026-11-03 · by Hannah Vernon · in t-sql

Map which SQL Server trigger writes to which table before you change a legacy schema, and see what happens at the 32-level nesting limit.

INTERSECT and EXCEPT: Where NULL Finally Behaves

2026-09-26 · by Hannah Vernon · in t-sql

INTERSECT and EXCEPT treat NULL as equal, the one place NULL comparison behaves as expected. Use them for NULL-safe row comparison.

One NULL in a Unique Key, and None Across a Join

2026-09-25 · by Hannah Vernon · in t-sql

A UNIQUE constraint allows one NULL but rejects a second, and an equi-join drops NULL keys. Filtered indexes and NULL-safe joins.

ISNULL vs COALESCE: Not as Interchangeable as They Look

2026-09-24 · by Hannah Vernon · in t-sql

ISNULL and COALESCE differ on result type, truncation, nullability, and how often they evaluate their input. When to use each.

1 2 … 8 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