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

Copilot Code Review and the 4,000 Character Limit

2026-07-29 · by Hannah Vernon · in AI for DBAs

Here is a fun way to lose an afternoon: carefully write coding standards into your repository’s .github/copilot-instructions.md, request a Copilot code review on a pull request that violates several of them, and watch the review…

Getting Your AI Agent to Actually Follow Your Instructions

2026-07-28 · by Hannah Vernon · in AI for DBAs

There is a special kind of frustration in watching an AI agent cheerfully do the exact thing your instructions file tells it not to do. You wrote the rule. The rule is right there. The…

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…

Teaching Your AI Assistant to Remember: Session Checkpoints for Multi-Day Work

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

If you’ve used an AI coding assistant for anything beyond a quick one-off question, you’ve hit the wall: the conversation context runs out. You start a new session, and the assistant has no idea what…

Getting Started: Your First Hour with GitHub Copilot CLI

2026-04-23 · by Hannah Vernon · in AI for DBAs

Install GitHub Copilot CLI, run your first prompt, and understand how the context window works. A hands-on setup guide for SQL Server DBAs.

Teaching GitHub Copilot Your T-SQL Coding Standards

2026-04-01 · by Hannah Vernon · in t-sql, tools

If you’re a DBA or database developer using GitHub Copilot CLI, you’ve probably noticed it generates functional T-SQL – but not necessarily T-SQL that matches your team’s coding standards. After several weeks of working with…

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