Problem
SSMS 21 is a new version of SQL Server Management Studio. In this article, we look at how download SSMS, install and what’s new.
Solution
This article will explain how to download, install, and configure SSMS 21 and explain what’s new in this version. We will explain different features like Git and GitHub integration, new installation and updates features, Visual Studio integration, the Always encrypted options, and more.
OS Requirements
The following OSs are supported for SSMS 21:
- Windows 11 (Home, Pro, Pro Education, Pro for Workstation, Enterprise, and Education).
- Windows 10 (Home, Professional, Education, and Enterprise).
- Windows Server 2022, 2019, and 2016 Standard and Datacenter.
Hardware Requirements
Below is a list of the hardware necessary to run SSMS 21:
- X64 processor.
- At least 4 GB of RAM (16 recommended).
- At least 4 GB of disk space (SSD recommended).
- Minimal 1366 x 768 video card display resolution but 1920 x 1080 is recommended.
Additional Requirements
It is also necessary to have the following:
- Administration rights to install.
- .NET framework 4.7.2 installed or higher.
How to Download SSMS 21
Use the following link to download SSMS 21: Download and Install SQL Server Management Studio 21.
Download the installer and run it from your local machine.
How to Install SSMS 21
Step 1: Run the installer.
Step 2: You will receive an agreement message. Read the Microsoft Privacy Statement and the Microsoft Software License Terms and click Continue.
Step 3: Click Install.
As you can see, SSMS 21 is integrated with Visual Studio now:
Step 4: When the installation is complete, click OK. Then, reboot your system.
Getting Started with SSMS 21
Once installed, open SSMS 21. Note: It now has a blue icon; the yellow icon is no longer available.
The popup window is blue as well.
You can optionally sign in with your Microsoft Windows account or use your GitHub account.
We can import the settings from different SSMS versions or skip this option. There are three options to import data from earlier SSMS versions (if any).
New Login Encryption Options
Now available are these connection security options when you try to connect to SQL Server:
- Optional allows you to connect with secure encryption if the server supports encryption. Otherwise, it will not work with an encrypted connection.
- Mandatory forces to encrypt all the connections. You can trust a server certificate, if necessary.
- Strict is available for SQL Server 2022 and Azure only. This option requires a trusted certificate authority. A trust server certificate is not allowed.
What’s New in SSMS 21?
New Version Updates
First of all, you can easily update and check new versions of SSMS using the Visual Studio Installer. The new SSMS uses the VS Shell now.
Open the Visual Studio Installer. If a new version is available, click Update to update your SSMS to the last version available.
Git and GitHub Integration
With Git and GitHub, you can have a local repository or a Web repository to store versions of your code. For example, if you have several SQL files with code, you can track historical changes with Git or GitHub.
With Git, you can have a local repository plus store and recover your code from the repository. GitHub is a nice platform to share your code with a community and work with DevOps.
For more information:
- Git: SQL Server Data Tools in Visual Studio with GIT Source Control
- GitHub: Getting Started with GitHub for SQL Server Developers
- DevOps: Getting Started with DevOps and SQL Server
To use Git, make sure to have it installed.
Once installed, in SSMS, go to Git > Create a Git Repository.
You can create a Git or GitHub repository or work with the Azure DevOps reps. In this example, we will create a Local Git Repository and a GitHub connection.
You can keep the Git Repository default options or change the local path. To create a new repository in GitHub, click the Sign In… option in the Account drop box.
You will be asked to authorize the connection from SSMS to GitHub. You may also receive an email to validate the connection. This step may depend on your GitHub security settings.
If everything is OK, you will have a new repository in GitHub:
Also, you have access to different views. In the menu, go to View and select Git Repository or press Ctrl+O or Ctrl+R.
You will be able to see the Git Repository with all the branches.
In addition, you have the Git Changes option to check the changes applied in Git.
You can visualize the Git Changes here:
SSMS Dark Theme
Another famous request is the dark theme. SSMS now supports the dark theme:
To configure the dark theme, go to the menu and select Tools > Options.
In the Options window, go to General and select the Dark color theme.
Always Encrypted Wizard
SSMS 21 includes a wizard to configure the Always Encrypted feature.
You can use the wizard at different levels. At the database level, you need to select the database, right-click, and select Tasks > Always Encrypted Wizard.
The wizard is user-friendly and guides you through encrypting your data.
It is also possible to use the Always Encrypted Wizard at table level.
In SSMS, in the Object Explorer, right-click a table and select Always Encrypted Wizard.
For more information about Always Encrypted, refer to SQL Server 2016 Always Encrypted.
Additional New Features
- SSMS 21 supports 64-bit, ultimately improving the performance of the tool.
- You can now create logins and database users for Azure SQL.
- In the database properties, you now have a new Configurations page with database-scoped options.
- The drivers for the Microsoft.Data.SqlClient (MDS) is 5.1.6.
- The SMO version was updated to version 17.100.52.
- The System.Text.Json was updated to version 8.0.4.
Next Steps
For more information about SSMS 21, visit:
