SQL Server Science
Technical Articles for the DBA / Developer
Home » ai-agent » Page 3

Generating Compliance Evidence with AI

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

Generate SOX, PCI-DSS, and HIPAA audit evidence with AI from your actual SQL Server configuration.

Scanning Stored Procedures for SQL Injection with AI

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

Use AI to audit stored procedures for SQL injection EXEC patterns, QUOTENAME misuse, and second-order injection risks.

Mapping Permission Sprawl with AI

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

Audit who has what access and through what path AI traces permissions through roles, nested groups, and CONTROL chains.

Finding and Fixing Orphaned Users with AI

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

Find orphaned database users with AI SID mismatches, dropped logins, contained DB users, and Azure SQL differences.

Memory Grant Analysis with AI

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

Find queries with excessive memory grants, tempdb spills, and RESOURCE_SEMAPHORE waits using AI analysis.

Blocking Chain Triage with AI

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

Analyze blocking chains with AI to identify head blockers and get actionable resolution steps.

« Previous 1 2 3 4 … 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