Blog Post

SQL Server Blog
3 MIN READ

Announcing SQL Server Management Studio (SSMS) 21 Preview 1 and Copilot in SSMS

erinstellato's avatar
erinstellato
Icon for Microsoft rankMicrosoft
Nov 06, 2024

The SQL Tools team is pleased to announce the upcoming release of SQL Server Management Studio (SSMS) 21 Preview 1, and the upcoming Private Preview of Copilot in SSMS.

 

SSMS 21 is a modernized version of the tool that millions of SQL data professionals use every day.  This starts with SSMS moving from reliance on the deprecated Visual Studio 2015 Shell to being a Visual Studio 2022 based solution with 64-bit support.  Moving to the latest version of Visual Studio means that SSMS picks up new functionality within the Query Editor, such as support for vertical tabs and their sort order, and customization of the cell and font colors for NULL values in the results grid. It also means that SSMS 21 will be installed using the Visual Studio Installer which brings support for automatic updates, command line installs, and more.  

 

Long-time SSMS users will be thrilled to see the return of Git integration in SSMS 21 Preview 1, which sets the stage for eventual support of SQL Projects in SSMS.  Further, many of you will be happy to see the initial stages of support for dark theme.  Yes, you read that correctly!  We are bringing proper support for dark theme to SQL Server Management Studio in a phased approach.  While we cannot pause all work for SSMS to exclusively focus on implementing dark theme support for every SSMS dialog, we can concurrently work on updates to dialogs, starting with those accessed most frequently and systematically moving throughout the UI. 

 

In addition to new features and functionality, Preview 1 has improvements to Always Encrypted, explained in more detail in Pieter’s post, and we’ve also added a new page that lists the Database Scoped Configuration settings in the database properties dialog.

 

SSMS 21 Preview 1 also includes a resolution for folks that use Central Management Servers and had challenges with the enhanced security options – you can now save the Trust Server Certificate option in your CMS connections.

 

On the extension front, SSMS 21 will have support equivalent to what exists in the current release of SSMS 20.  Specifically, third-party extensions can be created and used with SSMS 21.  Full support for extensions, including the ability to browse extensions from within SSMS, presence in the Visual Studio marketplace, and support of the VSIXInstaller is on our roadmap and we will share details when appropriate.

 

Previous releases of SSMS have had at least one preview, if not two or three.  Users can expect multiple previews for SSMS 21, with regular frequency.  A regular preview cadence allows us to work on implementation of new features such as support for creating Azure logins and users through the UI (not simply via T-SQL) and an improved Azure Authentication experience.  Additional features will be available in subsequent previews, including improvements to startup time, a new connection experience, consolidated settings, and Copilot in SSMS.

 

Copilot in SSMS will start with a chat for the Query Editor, leveraging both connection and database context to answer your general SQL questions and help you write T-SQL based on natural language prompts.  For NLtoSQL prompts, Copilot queries the database metadata to provide context about the tables and views in your database, and it can also assist with fixing and explaining T-SQL queries.

 

We are at the beginning of our journey with Copilot in SSMS, and we plan to follow up the Query Editor chat with inline support for NLtoSQL directly in the editor window. Subsequent areas of focus will be based on your feedback – we want to know the areas of SQL you need help with, and the most critical problems you want Copilot to solve.  We will launch the Private Preview for Copilot in SSMS within the next month.  If you would like to take part and have an early hands-on experience with this new capability, please use this link to indicate your interest: https://aka.ms/ssmsinterest.  

 

We are extremely excited about the upcoming release of SSMS 21 Preview 1!  Thank you for your patience as we have endeavored to take on the task of rebuilding SSMS from the ground up.  The opportunity to download the first preview will soon be available, stay tuned for the official announcement.

Updated Nov 06, 2024
Version 1.0
  • camaro322hp's avatar
    camaro322hp
    Copper Contributor

    Thrilled to see a dark theme on the the way.  Thank you for making that happen.

    erinstellatoI need one of those SSMS 21 dark theme t-shirts Erik was wearing at PASS.  Where can we buy those?

  • VladDBA's avatar
    VladDBA
    Copper Contributor

    This is excellent news! Can't wait for the preview release.

  • camaro322hp The shirts were given away at Summit, there is not a purchase option.  We will likely have additional swag in the future to share at events.

  • robertwmcnulty's avatar
    robertwmcnulty
    Copper Contributor

    "SSMS 21 will be installed using the Visual Studio Installer" - will this have any implications to SSMS being available free for "Enterprise" users?  For an "Enterprise" (any organization with more than 250 PCs or more than 1 million dollars in annual revenue) using the "free" Visual Studio Community edition in many capacities is against the license terms.  Getting all users who utilize SSMS in an organization licensed for Visual Studio Professional is a very expensive prospect that would make SSMS 21 prohibitively expensive to adopt for our organization if it was required. 

    While the Visual Studio Community License terms do have exemptions allowing for Enterprise use of Visual Studio Community for "SQL Server Development", our legal team has nevertheless had significant concerns with any use of the SQL Server tools in Visual Studio by any user without a full Professional License due to the ambiguity of whether database administration and/or development of content that utilizes SQL Server qualifies as "SQL Server development" under the license terms.

    If future versions  of SSMS will exclusively be installable via Visual Studio, will the licensing terms of Visual Studio Community be updated to broadly allow any user at "Enterprises" to perform anything related to SSMS functionality for free?  This issue has been avoided in traditional SSMS by being an entirely separate installation with its own licensing terms.

  • robertwmcnulty SSMS 21 is installed separately from Visual Studio and will continue to be free for Enterprise users.  There is no Visual Studio license required in order to use SSMS.  SSMS does not install any version of Visual Studio (e.g. Community, Enterprise).  SSMS does not require Visual Studio to be installed.  SSMS is not an extension or workload of Visual Studio.

    • robertwmcnulty's avatar
      robertwmcnulty
      Copper Contributor

      I understand that one won't need Visual Studio itself installed.  However, at the time of writing I'm not seeing any way to install the "Visual Studio Installer" without downloading running an edition of the Visual Studio bootstrapper, which prompts one to agree to the "Microsoft Software License Terms" which will depend on which bootstrapper one downloaded.

      The Community terms state that "If you are an enterprise, your employees and contractors may not use the software to develop or test your applications" with some listed exceptions.

      The Professional terms state that until one acquires a "valid full-use license, the software is a trial edition" and that "You may only use the trial edition or preview channel software for internal evaluation purposes"
      So, I don't see any publicly available path for getting ahold of the Visual Studio Installer "Application" without being bound to the Visual Studio Licensing terms.

      Will an alternative bootstrapper be provided for SSMS installations if/when SSMS is installed via the Visual Studio Installer?

  • ArminMesri's avatar
    ArminMesri
    Copper Contributor

    I believe this new version could greatly assist developers in writing T-SQL commands more efficiently.

    • erinstellato's avatar
      erinstellato
      Icon for Microsoft rankMicrosoft

      Łukasz As noted in the blog post, it's an upcoming release, which means it is not yet available to download.

  • fabianHanu's avatar
    fabianHanu
    Copper Contributor

    And here I am looking at my "You don't need dark mode when you've got SQL community" from this year SQL Bits conference. 

    Btw, 3.6 GB? Thats seems a lot.