Today at Microsoft Ignite, we're releasing SQL Server Management Studio (SSMS) 22.12.1. Our teams have been working hard to bring you lots of new and exciting capabilities! This release introduces local Azure SQL Database container creation and management (preview), a new Copilot chat experience (preview), support for bringing your own model, a way to keep unfinished queries between sessions, and more.
Download SSMS 22.12.1, or update your existing installation. Here's a look at what's new.
Local Azure SQL Database containers (preview)
You can now create and manage a local development resource in SSMS without an Azure subscription! The local Azure SQL Database container deployment wizard (preview) allows you to create a container directly from SSMS using Docker Desktop.
Select Create Azure SQL Database container (preview) in the Object Explorer toolbar to open the wizard. You can deploy, start, stop, and delete containers without running Docker commands yourself by right-clicking the container in Object Explorer and selecting from the Container Tasks menu.
Migration Assistant updates
We’ve improved assessment performance for SQL Server instances with many databases. Migration assessments for Azure SQL Database now also include elastic pool recommendations to help you plan your migration.
A new Copilot chat experience (preview)
We're introducing an opt-in chat experience built on the GitHub Copilot SDK. This update is designed to deliver faster responses, more efficient token usage, and more capable agents for database tasks.
Agent mode can take actions, including executing queries and working with database objects. Ask mode provides read-only assistance with queries, errors, and execution plans. Copilot can use context from any open SQL editor, including its connected server and database.
You can also ask Copilot to open SSMS tools such as Activity Monitor, XEvent Profiler, Schema Compare, and Generate Scripts.
To try it, go to Tools > Options > GitHub > Copilot > Copilot Chat and select Use new Copilot chat experience.
Bring your own model (preview)
The new chat experience also lets you connect your own model provider. The preview supports Microsoft Foundry, OpenAI, Anthropic, and Ollama, including custom URLs for OpenAI and Ollama.
BYOM works in Agent mode, whether or not you're signed in to GitHub. Not every model supports every Agent mode capability.
Choose how you want to connect to AI.
After enabling the new chat experience, open the model picker and select Add a model or Manage models, then Add model provider.
Pick up where you left off (preview)
If you keep unfinished queries open while working through a problem, this one's for you. SSMS can now preserve your open query tabs and unsaved edits when you close it, then restore them when you return.
Enable Reopen unsaved documents on solution load or empty environment under Tools > Options > Projects and Solutions.
Easier bacpac and dacpac workflows (preview)
The Database DevOps team has updated the package workflows:
- Create bacpac/dacpac: Export schema and data as a .bacpac, or schema only as a .dacpac.
- Apply bacpac/dacpac: Review clearer deployment previews, with better validation and progress reporting. You can also generate a deployment script for a .dacpac before applying changes.
- Create database from bacpac/dacpac: Create a database and apply a package through a guided workflow.
Include data for a bacpac, or leave it out for a schema-only dacpac.
Open Fabric Database Hub from SSMS and SQL Database in Fabric Creation
Right-click an Azure SQL database in Object Explorer and select Open in Fabric Database Hub to view its health, performance, and other available insights. The action is also available for groups in Registered Servers.
Also added in this release, you can now create and delete SQL Databases in Fabric directly from SSMS, without having to switch to the Fabric portal.
Custom number formatting in the results grid and other everyday fixes
You can now choose digit grouping and decimal symbols for numeric values in the results grid. Enable Use custom number formatting under Tools > Options > Query Results > SQL Server > Results to Grid.
This changes the display, not the underlying values. Copying or dragging retains the displayed formatting; saving or exporting uses the raw values.
A few more updates worth calling out:
- Generate Scripts (Preview) adds searchable object selection.
- SQL Formatter adds JOIN/APPLY indentation settings and an option to start the SELECT list on a new line.
- Connections have better keyboard navigation. Fixes address lost history after a domain password change and hidden buttons at 150% display scaling.
- Save Results As remembers your last folder instead of returning to Documents.
- Activity Monitor session details now support dark theme.
As always, the release notes have the full list. Try the update and let us know what works, what doesn't, and what's missing on the SSMS feedback site. Thanks for helping us improve SSMS.