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

A Junior DBA’s Field Guide to This Series: What Your Mentor Forgot to Explain

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

A companion guide for junior DBAs navigating the ALTER DBA ADD AGENT series. Maps the vocabulary walls, production safety gaps, and confidence calibration challenges that experienced readers won’t even notice.

SQL Server Patching Pre/Post Checks with AI

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

Generate matched pre-patch and post-patch validation scripts with AI for safe SQL Server patching.

Smart DBCC CHECKDB Scheduling with AI

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

Build intelligent CHECKDB scheduling with AI size-based estimates, window optimization, and corruption alerting.

AI-Generated Availability Group Failover Runbook

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

Generate a complete AG failover runbook with AI pre-flight checks, failover, validation, and rollback in PowerShell.

Building a Backup Automation Framework with AI

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

Build a real backup automation framework in PowerShell with AI multi-instance, retention, verification, and dbatools.

Backup Failure and Gap Detection with AI

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

Catch missed and failed backups before they become an RTO/RPO crisis with AI-built monitoring.

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