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

Setting Up Your Three-Layer Backup

2026-05-31 · by Hannah Vernon · in Opinion

This is Part 3 of a series. In Part 1, I argued that open source licenses protect your code but not the infrastructure around it. In Part 2, I surveyed the landscape of options for…

Where Should Your Code Live Besides GitHub?

2026-05-30 · by Hannah Vernon · in Opinion

This is Part 2 of a series. In Part 1, I made the case that open source licenses protect your code but not the infrastructure around it. GitHub, npm, and the platforms we depend on…

Your Code Is Open Source. Is It Yours?

2026-05-29 · by Hannah Vernon · in Opinion

Open source licenses protect your code’s freedom. But when the platforms that host, distribute, and discover that code are controlled by a handful of US corporations, how free is it really?

Part 2: When the AI Code Reviewer Finds Bugs the Optimizer Didn’t

2026-03-20 · by Hannah Vernon · in DMVs, performance, t-sql

In Part 1, I walked through an interactive session with GitHub Copilot CLI where we optimized a production T-SQL function - cutting memory grants by 80% and logical reads by 73%. I thought we were…

Can GitHub Copilot Optimize Your T-SQL? I Put It to the Test

2026-03-20 · by Hannah Vernon · in DMVs, performance, t-sql

I’ve been curious about how well AI coding assistants handle real-world T-SQL optimization - not textbook examples, but production code with system DMVs, Availability Groups, and windowed functions. So I pointed GitHub Copilot CLI at…

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