Beyond Traditional DBA Practices - Transforming T-SQL Script Expertise into AI AgentsSQLBits 2026
If you're managing SQL Server instances, you know the drill—you've built up a collection of diagnostic scripts over the years including queries to check for blocking sessions, identify slow-running procedures, monitor disk space, and analyze index usage that represent your expertise developed after years of troubleshooting database issues at 2 AM. Here's what's interesting: those scripts can now become the foundation for AI agents that work around the clock, transforming your T-SQL knowledge into agentic AI tool framework through the Model Context Protocol (MCP), agentic frameworks, and secure hosting environments.
In this session, you will learn how to convert your proven diagnostic queries into tools that Large Language Models can contextually select and execute based on real-time database conditions. You will discover how to build AI agents that understand context, make informed decisions, and execute complex operations autonomously while exploring critical guardrails that ensure responsible operation in production environments. The session covers practical implementation patterns and real-world examples of how your T-SQL expertise can work 24/7 through AI automation while maintaining enterprise reliability standards