Welcome to the world of SQL Copilots

on YouTube ↗45m

" summary

Azure adds a Copilot for Azure SQL that demos about 40 skills (team cites ~55 total) and uses Azure OpenAI without fine‑tuning on customer data. It queries DMVs, Query Store and diagnostics, reads schema/keys (not row data), identifies a high‑CPU query executed ~16,000 times, suggests an index definition, spots blocking sessions, and generates runnable T‑SQL from natural language (pivot, rank). Preview is gated, permission‑aware, mostly read/advise today with execution gated by user consent.

AI-written summary · about

" chapters (13)

1. 0:00SQL Copilots intro
2. 1:50What are SQL Copilots
3. 3:56Azure Copilot & natural SQL
4. 8:50Demo: DB size & performance
5. 10:13High CPU & query tuning
6. 12:20Query store troubleshooting
7. 13:23Blocking processes with Copilot
8. 15:51Natural SQL in editor
9. 25:21How SQL Copilot works
10. 32:40Copilot reliability & limits
11. 33:21Pricing & availability
12. 36:11Sign up for preview
13. 42:14Q&A

" related talks

• 45mWelcome to the world of SQL CopilotsBob Ward, Joe Sack · SQLBits 2024
• 09mHarness Microsoft Copilot in Azure for Azure SQL DatabaseMuazma Zahid · Microsoft Build 2024
• 40mAI Studio - Creating and scaling your custom copilotsNabila Babar, Asha Sharma, Hanchi Wang · Microsoft Build 2024
• 47mUnlock potential on Azure with Microsoft CopilotMatt Winkler, Ruhiyyih Mahalati · Microsoft Build 2024
• 36mWhat's new with Copilot StudioKendra Springer, Omar Aftab, Aarthy Longino, Gary Pretty, Jack Rowbotham, Peter Swimm · Microsoft Build 2024
• 47mGitHub Copilot for SQL Development: Integrating the Power of AI into Database DevelopmentSubhojit Basak · SQLBits 2024
• 45mThe era of the AI CopilotGreg Brockman, Kevin Scott · Microsoft Build 2023
• 45mBuilding a copilot: Azure AI Studio or Copilot StudioHenk Boelman, Daniel Laskewitz · Microsoft Build 2024