Converting Implicit Joins to ANSI Syntax with AI
Use an AI agent to convert legacy implicit joins to ANSI JOIN syntax safely.
How This Series Was Written: A DBA and an AI Walk Into a Terminal
This entire blog series was co-written with an AI coding agent. Here’s the transparent, behind-the-scenes story of how it was produced.
The AI-Augmented DBA Team: Mentoring and Knowledge Transfer
How AI coding agents change team dynamics for DBAs knowledge transfer, mentoring junior staff, and building a culture of AI-augmented database work.
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.