Hey folks! As we are working toward Agent mode for GitHub Copilot in SSMS, we have been working with several amazing folks internally to develop skills for the agent. Examples include*:
(*this is not a complete list!)
What other skills would you like to see for Agent mode?
Friday Feedback this week is about a new option we're adding for GitHub Copilot in SSMS related to security. Buckle up, this is a lot of info... 💺
There have been several feedback items asking for more control over what queries can be run by GitHub Copilot. By default, GitHub Copilot in SSMS executes queries under the context of the user connected to the database.
While I believe that any user, regardless of whether they use GitHub Copilot or not, should have their permissions configured based on the principle of least privilege, there is still a case for a separate user or login for GitHub Copilot.
Our engineers came up with a creative solution that uses existing security capabilities in SQL: EXECUTE AS and IMPERSONATE.
Thoughts? Concerns? Who wants to see a blog post with examples?
We've been making incremental changes to the settings in SQL Server Management Studio (SSMS) thanks to Visual Studio ☑️ Have you noticed the new Unified Settings pane? Do you have a favorite new option (added in SSMS 21 or 22) that you think everyone should know about?
(I admit, I thought I would love vertical tabs, but I keep going back to my old school ways)
You can learn more about settings from Makena and Anna in a new Data Exposed video 🤗
Make SSMS 22 Work For You: How to Customize Your Environment | Data Exposed
Friday Feedback on May Day! 💐
This week we're looking for feedback about creating databases in SQL Server Management Studio (SSMS).
Do you create Azure SQL databases from SSMS? Did you try to create one, but ran into issues, and if so, what issues did you have?
We know we can improve the experience, but we also know that sometimes it's better (easier?) to create the database in the Azure portal or with the Azure CLI. Interested to hear constructive suggestions and thoughts here, thanks!