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

A Guardrail Only Humans Enforce Isn’t One

2026-10-29 · by Hannah Vernon · in Hot Takes

MongoDB won’t stop you querying a collection that doesn’t exist, or storing mismatched documents side by side. That’s by design, and it has a cost.

Acronyms, Collisions, and the Cost of Not Asking

2026-08-22 · by Hannah Vernon · in Hot Takes

I promised a follow-up to a post about tech vocabulary,[1] and this is it. That one argued that dramatic words and vague words fail the same way: they carry attitude where information should be. I…

The Blast Radius Was Four Rows

2026-08-20 · by Hannah Vernon · in Hot Takes

A while back I read an incident report that described the “blast radius” of a “catastrophic” data issue. I kept reading, looking for the part where something exploded. The actual damage: four rows in a…

A Decision Framework (and When to Stop Arguing)

2026-06-15 · by Hannah Vernon · in Data Architecture

This is the finale of the “Where Does Business Logic Live?” series. Over five posts we have looked at , the , the , the reality, and the . Now let’s make it actionable. This…

Security, Misconceptions, and Hybrid Architectures

2026-06-14 · by Hannah Vernon · in Data Architecture

This is Part 5 of the “Where Does Business Logic Live?” series. We have made the , the , and the comparison. Three things remain before we can build a decision framework: how security actually…

Where Does Business Logic Live? A DBA’s Guide to the Stored-Procedures-vs-Application-Layers Debate

2026-06-09 · by Hannah Vernon · in Data Architecture

Few architecture questions generate more heat and less light than this one: should business logic live inside SQL Server stored procedures, or outside the database in application layers? Ask a room of developers and DBAs…

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