SQL Server Science
Technical Articles for the DBA / Developer
Home » Archives for Hannah Vernon » Page 9

Writing T-SQL with an AI Partner

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

Use AI to write T-SQL faster generating functions, complex JOINs, window functions, and optimization suggestions. Practical prompts for real DBA work.

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.

What Can an AI Coding Agent Actually Do for a DBA?

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

A survey of every DBA task area where AI coding agents add real value from T-SQL writing to security audits, incident response, and migration planning.

The DBA’s Blind Spot: Why AI Coding Agents Are Coming for Your Workflow

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

AI coding agents like GitHub Copilot CLI aren’t just autocomplete they read your files, run commands, and iterate. Here’s why DBAs can’t afford to ignore them.

ALTER DBA ADD AGENT: Practical AI for Database Professionals

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

A practical guide to using AI coding agents for SQL Server database administration. 18 posts covering T-SQL, monitoring, security, migrations, and more.

Inspecting SQL Server TLS Certificates Without Credentials

2026-04-15 · by Hannah Vernon · in security, tools

If you’ve ever needed to check the TLS certificate on a SQL Server instance — whether it’s expired, misconfigured, missing SANs, or just plain self-signed — you’ve probably had to connect with SSMS, run some…

« Previous 1 … 8 9 10 … 31 Next »

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • DMVs
  • documentation
  • extended-events
  • Internals
  • maintenance
    • patching
  • performance
  • 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