GitHub Copilot for SQL Development: Integrating the Power of AI into Database Development
summary
Demo shows GitHub Copilot hooked into IDEs (notably Azure Data Studio) using a GitHub account and the Copilot extension with subscriptions from $10/month. Copilot takes session text or pasted DDL for contextualization and generates SQL: tables, inserts, stored procedures, a join query with three joins, group by and three arithmetic ops, and even creates non-clustered index to cut a 165 ms elapsed time. Code goes through a GitHub proxy for PII and duplicate checks; Enterprise keeps data inside the tenant.
AI-written summary · about
chapters (10)
- 0:00GitHub Copilot for SQL intro
- 5:12What is Copilot and how it works
- 9:10Setup Copilot for SQL
- 15:44Data privacy and security
- 21:57Natural language to SQL demos
- 26:28Context for accurate SQL
- 31:47AI stored procedures/functions
- 36:10Performance optimization
- 37:58Key takeaways
- 43:19Q&A
related talks
01h 00mLevel up with GitHub Copilot: using AI to learn, code, and build
01h 00mGitHub Copilot, using AI to help you learn, code, and build
42mWhat’s new in GitHub Copilot and Visual Studio
01h 20mGithub Copilot - The World's Most Widely Adopted AI Developer Tool
52mInject the power of the cloud and AI into your development workflow
09mHarness Microsoft Copilot in Azure for Azure SQL Database
01h 02mLevel up with GitHub Copilot: using AI to learn, code, and build
40mLevel Up with Copilot