Introducing Agent mode in SQL Server Management Studio (SSMS) | Data Exposed
Skills:
AI Pair Programming90%
Key Takeaways
Introducing Agent mode in SQL Server Management Studio using GitHub Copilot
Original Description
GitHub Copilot Agent mode (preview) in SQL Server Management Studio (SSMS) lets you specify a high-level goal in natural language and have Copilot work through it by executing queries, reading files, and iterating on its own outputs until the task is complete or your input is needed. Learn all about it from Erin Stellato.
✅ Chapters:
0:32 What is agent mode in SSMS
1:13 Agent mode demo starts
2:05 Tour of agent mode options in SSMS
4:04 Example for performance troubleshooting
5:46 Agent mode read only by default, but you can change it
7:10 How to changes default accepts and also read/write mode
8:28 Tips and tricks
✅ Resources:
GitHub Copilot in SSMS video series: https://www.youtube.com/playlist?list=PL3EZ3A8mHh0wew8yf4hodr3PQDxDh7sLt
Docs: https://learn.microsoft.com/ssms/github-copilot/agent-mode
📌 Let's connect:
LinkedIn - https://www.linkedin.com/in/erinstellato/
Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna
Twitter - AzureSQL, https://aka.ms/azuresqltw
🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt
#AzureSQL #SQL #LearnSQL
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
More on: AI Pair Programming
View skill →Related Reads
📰
📰
📰
📰
You don’t need to learn to code anymore.
Medium · Programming
The One-Person Billion-Dollar Company: How AI Is Rewriting the Rules of Business Forever
Medium · AI
Your Agent’s Safety Classifier Approved the Malware. It Was Working Exactly as Designed.
Medium · AI
The Generative and Agentic Frontier in Financial Services: A Comprehensive Analysis of AI in…
Medium · AI
Chapters (7)
0:32
What is agent mode in SSMS
1:13
Agent mode demo starts
2:05
Tour of agent mode options in SSMS
4:04
Example for performance troubleshooting
5:46
Agent mode read only by default, but you can change it
7:10
How to changes default accepts and also read/write mode
8:28
Tips and tricks
🎓
Tutor Explanation
DeepCamp AI