Today we released a smaller SQL Server Management Studio (SSMS) update, version 22.5.2, to address a few issues related to GitHub Copilot and SQL Projects. As always, we recommend that users update to the latest release when it’s available, as it’s the generally available and supported release. You can view the release notes for more details related to the fixes, and with both SQL Projects and copilot, we continue to monitor customer feedback and add functionality with each release. If you’re using either feature, we appreciate you trying out what’s new and reporting any issues or requests on the feedback site.
GitHub Copilot completions
With this release there’s an important change for GitHub Copilot in SSMS that I want to call out. We have disabled completions by default. For those of you who previously changed your completions setting, they are unaffected. Not sure? No worries, go to Tools > Options > Text Editor > Inline Suggestions. There are three options under Suggestions Providers. If any of them are selected, then completions within the editor are enabled. If none of them are selected, then completions are disabled. Feel free to enable completions if you find them useful!
Wait…why did you disable completions by default?
Good question, I’m glad you asked. There has been feedback that completions are inaccurate, and until there is higher confidence in the suggestions, the decision was made to disable completions by default.
Will you enable completions by default again?
I hope so! We first need to identify what’s causing some of the issues we’ve seen folks mention and determine next steps after that. We want to ensure that using completions doesn’t create high levels of friction or frustration.
Anything else we should know?
Since you’re here, a couple weeks ago I posted about Agent mode for GitHub Copilot in SSMS and shared a feedback item with a few questions. For those of you that use, or are thinking about using, GitHub Copilot, we would love your input.
These questions align with some existing requests related to copilot permissions; feel free to upvote those requests as well:
- Restrict Copilot to only run read queries (no DML or DDL)
- SSMS Copilot Security - Restricting access beyond user access
We’ve heard your concerns about GitHub Copilot and security, and we’re making changes that will allow customers to more finely control what queries GitHub Copilot can execute. Stay tuned.
Microsoft