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

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.

Monitoring Long-Running Transactions with AI-Built Alerts

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

Build long-running transaction monitoring with AI smart thresholds and Database Mail alerting.

Building Custom Monitoring Queries and Alerts

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

Build custom SQL Server monitoring queries and alerts with AI long-running transactions, blocking chains, backup failures, and intelligent thresholds.

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