AI Meets SQL Server: Smarter Query Tuning with Generative AI with Pinal Dave
What happens when you give AI a slow SQL Server query, access to a development environment, and a challenge to improve performance? @PinalDaveSQLAuthority puts ChatGPT and Claude to work in this hands-on SQL Server session, with live demonstrations of query optimization, custom monitoring dashboards, deadlock investigation, and AI-assisted troubleshooting. You'll see how adding SQL Server context changes AI recommendations, how Claude tests an optimized stored procedure against the original results, and why keeping AI permissions under control matters just as much as getting a faster query. **What you'll learn:** - How to give AI useful SQL Server performance context - How to use AI to investigate and optimize slow stored procedures - Why verifying identical query results matters - How to build a custom live SQL Server monitoring dashboard - How to investigate deadlocks using SQL Server's system_health session - Why restricted access, testing, and DBA expertise remain essential Plus, a live demo that encounters a few unexpected surprises along the way. **Explore SQL Diagnostic Manager 14.3:** https://www.idera.com/sql-diagnostic-manager-14-3/?utm_source=YouTube&utm_medium=Video&utm_content=pinal-webinar-261022&utm_campaign=SQLDM143 **CHAPTERS** 00:00 Introduction: AI and the changing DBA workflow 01:40 Making AI practical for everyday SQL Server work 03:45 Demo: Investigating a slow stored procedure 06:40 Asking ChatGPT to analyze the query 08:35 Providing SQL Server context for better recommendations 10:42 When AI creates more work instead of less 13:05 Giving Claude controlled access to a development server 15:17 Automating query tuning and validating results 18:29 Looking beyond one query to server-wide performance 22:01 Building a custom live SQL Server dashboard 27:20 Reviewing the AI-optimized query results 31:08 Live dashboard troubleshooting and AI competency 36:53 Investigating SQL Server deadlocks with AI 43:00 Analyzing deadlock details and testing a proposed fix 48:18 Guardrails, accountability, and production safety 51:16 SQL Diagnostic Manager 14.3 preview and closing **About the speaker** Pinal Dave is a SQL Server performance tuning expert, consultant, and the founder of SQLAuthority, known for sharing practical SQL Server insights with the database community. #SQLServer #PerformanceTuning #PinalDave #DatabaseManagement #ArtificialIntelligence