Introducing Agent mode in SQL Server Management Studio (SSMS) | Data Exposed

Microsoft Developer · Beginner ·🤖 AI Agents & Automation ·4w ago

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

Related Reads

📰
You don’t need to learn to code anymore.
Discover how AI agents can generate playable games without requiring manual coding, revolutionizing game development
Medium · Programming
📰
The One-Person Billion-Dollar Company: How AI Is Rewriting the Rules of Business Forever
Learn how AI is enabling one-person billion-dollar companies, rewriting traditional business rules
Medium · AI
📰
Your Agent’s Safety Classifier Approved the Malware. It Was Working Exactly as Designed.
Learn how a simple 4-word prompt can trick AI agents into generating malware, highlighting the importance of robust safety classifiers
Medium · AI
📰
The Generative and Agentic Frontier in Financial Services: A Comprehensive Analysis of AI in…
Explore the intersection of AI, generative models, and agentic systems in financial services to understand their transformative potential
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
Up next
CLI vs API vs MCP Explained | Key Differences for AI Engineers
Pavithra’s Podcast
Watch →