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

Security Audits: Finding What You Missed

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

AI-assisted security audits for SQL Server finding orphaned users, permission sprawl, unencrypted connections, and compliance gaps across your fleet.

Incident Response: Root Cause Analysis with an AI Partner

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

Walk through a realistic production incident with an AI partner from initial triage through root cause analysis to post-mortem documentation.

Wait Stats, Deadlocks, and Blocking Chains: AI-Assisted Diagnosis

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

Use AI to interpret wait stats, analyze deadlock graphs, and diagnose blocking chains. Turn raw diagnostic data into actionable remediation steps.

Understanding Unfamiliar Code: Reverse-Engineering Legacy Procedures

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

Feed undocumented stored procedures to an AI agent and get clear explanations, dependency maps, and refactoring suggestions. Tame your legacy code.

PowerShell Automation: Backups, Maintenance, and AG Management

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

Let AI write your PowerShell automation scripts backup management, index maintenance, multi-server health checks, and Agent job deployment.

Automating Server Health Checks and Inventory Scripts

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

Generate server health check and inventory scripts with AI backup status, disk space, version audits, AG health, and configuration drift detection.

« Previous 1 … 7 8 9 … 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