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

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…

Performance and Operations: Measuring Instead of Arguing

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

This is Part 4 of the “Where Does Business Logic Live?” series. Parts and made the principled cases for the database and the application tier. Principles are where these debates start; measurements are where they…

The Case for Business Logic in Application Layers

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

This is the third post in the “Where Does Business Logic Live?” series, and it is the deliberate mirror image of the last one. In I made the strongest case I could for putting data-centric…

Self-Hosting Forgejo on Windows Server Hyper-V Step-by-Step

2026-06-01 · by Hannah Vernon · in tools

A complete walkthrough for running Forgejo on Debian 13 inside a Windows Server Hyper-V VM, with Docker Compose, Let’s Encrypt TLS, GitHub repo mirroring, and automated backups to a Windows network share.

Sharing GitHub Copilot Instructions Across Repos and Teams

2026-05-22 · by Hannah Vernon · in AI for DBAs

Your AI assistant starts every conversation as a blank slate. It doesn’t know your team uses COALESCE instead of ISNULL. It doesn’t know your naming conventions, your commit message format, or the three anti-patterns that…

Your Repository Is Just a Database

2026-05-13 · by Hannah Vernon · in Git for DBAs

If you’ve ever stared at a git tutorial and thought “why does this have to be so complicated?” — you’re not alone. Most git documentation is written by developers, for developers. It assumes you think…

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
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
    • wsus
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • 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