SQL Server Management Studio (SSMS) Versions – QA With Experts
In one of the previous article, I have mentioned How to download and install SQL Server Express which is free to use and then SQL Server management Studio (SSMS) which is a free tool to use with SQL Express to create database in it, so in this article, I have mentioned all the SSMS versions provided by Microsoft, and to note, SQL Server management studio (SSMS) is free to use and SQL Express is free to use for developer, you don’t need to buy license to use any of these.
SQL Server Management Studio (SSMS) is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server. Let’s take a look at all the versions provided available until now.
SSMS System Requirements
The current release of SSMS supports the following 64-bit platforms when used with the latest available service pack, here is the list of Supported Operating Systems:
- Windows Server 2022 (64-bit)
- Windows 11 (64-bit)
- Windows 10 (64-bit) version 1607 (10.0.14393) or later
- Windows 8.1 (64-bit)
- Windows Server 2019 (64-bit)
- Windows Server 2016 (64-bit)
- Windows Server 2012 R2 (64-bit)
- Windows Server 2012 (64-bit)
- Windows Server 2008 R2 (64-bit)
Supported hardware:
- 1.8 GHz or faster x86 (Intel, AMD) processor. Dual-core or better recommended
- 2 GB of RAM; 4 GB of RAM recommended (2.5 GB minimum if running on a virtual machine)
- Hard disk space: Minimum of 2 GB up to 10 GB of available space
Is SQL Server Management Studio Free?
Yes SSMS is free and probably will remain free, since it is a tool to create database, table or to perform queries on SQL Server database , as mentioned above and in this link: Is sql server management studio free to use?
What is the download size of latest version of SQL Server Management Studio (SSMS)?
SSMS 18.12.1 is half the size of SSMS 17.x. It has download size of 675MB as of now.
And SSMS 19.0 Preview 3 has download size of 613MB as of now.
