AI-Assisted Pull Request Reviews for Database Code
Use AI to review pull requests for database code catching performance issues, security gaps, and standards violations that human reviewers miss.
Teaching AI Your Environment: Custom Instructions and Context
Teach your AI agent your team’s T-SQL standards, naming conventions, and environmental context with custom instruction files. One-time setup, permanent payoff.
Version Control and CI/CD: Unlocking What the Agent Can Actually Do
AI agents become dramatically more powerful when your database code is in version control. Learn to set up Git repos and CI/CD pipelines for SQL Server.
Building Custom Monitoring Queries and Alerts
Build custom SQL Server monitoring queries and alerts with AI long-running transactions, blocking chains, backup failures, and intelligent thresholds.
AI-Native Monitoring: PerformanceMonitor, PerformanceStudio, and the MCP Revolution
Erik Darling’s PerformanceMonitor and PerformanceStudio bring MCP integration to SQL Server monitoring letting AI query your performance data directly.
Migration Planning: Compatibility Checks and Deprecated Features
Plan SQL Server version upgrades with AI deprecated feature scans, compatibility level analysis, breaking change detection, and migration runbooks.