From Queries to Agents: Bringing AI Workflows to SQL Server ~ Jeff Aalto

From Queries to Agents: Bringing AI Workflows to SQL Server with Vectors, MCP, and Azure Optimization

AI is becoming a core part of the SQL Server ecosystem, opening new possibilities for automation, tuning, and intelligent data operations. In this talk, we’ll explore how modern AI tooling integrates with SQL Server and Azure SQL—highlighting how MCP (Model Context Protocol) servers, SQL Server’s new vector functions and out of the box Fabric Data Agents can enable low code and pro code solutions. Finally, we’ll bring these pieces together with a pro code agentic recommendation engine that looks at workload and operational pattern configuration and pricing options and proposes cost and performance optimizations for Azure SQL Database. Attendees will leave with a practical understanding of how to apply AI-driven capabilities to real SQL environments today.