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

📰
Você está otimizando o custo da IA do jeito errado
Optimize IA costs correctly by understanding model usage and selecting the right tools, rather than just choosing cheaper models
Dev.to · Quézia Balonecker
📰
Two AI workers built one card. The handoff was the test.
Learn how two AI workers collaborated to create a trading card, with one worker rejecting and sending back the other's work without human intervention, demonstrating a significant milestone in AI autonomy
Dev.to AI
📰
The agent security gap: 54% of enterprises have already had an AI agent incident, and most still let agents share credentials
Most enterprises have had AI agent security incidents due to inadequate controls, highlighting the need for better agent security measures
VentureBeat AI
📰
The Rise of Agentic AI: Understanding, Building, and Leveraging Autonomous AI Agents for Business Transformation
Learn how to leverage agentic AI for business transformation by understanding and building autonomous AI agents
Dev.to 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
OpenClaw Tutorial for Beginners - Crash Course
Adrian Twarog
Watch →