GitHub Copilot in SSMS: Interacting with the Results Pane | Data Exposed
Microsoft Developer demonstrates a new capability in the latest SQL Server Management Studio (SSMS) release: using GitHub Copilot Chat with context from the SSMS results pane so you can ask questions about query output and diagnostics without leaving the editor.
Full summary based on description
What’s new in SSMS
- SSMS now supports interacting with the results pane using GitHub Copilot.
- The feature is designed to let Copilot Chat reference what you’re seeing after running a query.
What you can ask Copilot about
From the Copilot chat window in SSMS, you can ask questions about:
- Execution plans
- Interpreting plan operators and performance characteristics
- Understanding why a query might be slow based on the plan
- Messages tab
- Explaining warnings, errors, and informational messages returned by SQL Server
- Results grid
- Asking questions about the returned data (for example, what a column represents or patterns in the output)
Getting started
- Follow the official documentation for referencing the results pane in Copilot Chat:
Video chapters (from description)
- 0:00 Introduction
- 0:55 Demos
- 6:40 Getting started