SQL Server Management Studio is an integrated environment for managing your SQL Server infrastructure and Azure SQL Database. Management Studio provides tools to configure, monitor, and administer instances of SQL Server. It also provides tools to deploy, monitor, and upgrade the data-tier components, such as databases and data warehouses used by your applications, and to build queries and scripts.
- 40 SSMS Tips (by Konstantin Taranov)
- 36 SSMS Addins (by Konstantin Taranov)
- SSMS Snippets
- SSMS Shortcuts (by Konstantin Taranov)
- A month of SSMS tips and tricks (by Wayne Sheffield)
- SSMS Tricks & Shortcuts (by George Squillace)
- SSMS Tricks and Tips Ebook (by Greg Low)
- Download SQL Server Management Studio (SSMS)
- SQL Server Management Studio - Changelog (SSMS)
- SQL Server Management Studio (SSMS) - Release Candidate
- Previous SQL Server Management Studio Releases
- SQLSentry Latest Builds of Management Studio
- SQL Server Tools
- SQL Server Management Studio (SSMS)
- Microsoft Download Center SSMS
- Add Transact-SQL Snippets
This version of SSMS works with all supported versions of SQL Server (SQL Server 2008 - SQL Server 2017), and provides the greatest level of support for working with the latest cloud features in Azure SQL Database, and Azure SQL Data Warehouse. There is no explicit block for SQL Server 2000 or SQL Server 2005, but some features may not work properly. Additionally, SSMS 17.x can be installed side-by-side with SSMS 16.X or SQL Server 2014 SSMS and earlier.
This release of SSMS 17.x Version supports the following platforms when used with the latest available service pack: Windows 10, Windows 8, Windows 8.1, Windows 7 (SP1), Windows Server 2016, Windows Server 2012 (64-bit), Windows Server 2012 R2 (64-bit), Windows Server 2008 R2 (64-bit)
SSMS 18.x is not supported on Windows 8. Windows 10 / Windows Server 2016 requires version 1607 (10.0.14393) or later: Due to the new dependency on NetFx 4.7.2, SSMS 18.0 does not install on Windows 8, older versions of Windows 10, and Windows Server 2016. SSMS setup will block on those operating systems. Windows 8.1 is still supported.
SSMS 17.X is based on the Visual Studio 2015 Isolated shell, which was released before Windows Server 2016. Microsoft takes app compatibility very seriously and ensures that already-shipped applications continue to run on the latest Windows releases. Because of this, we do not anticipate that SSMS with all latest updates applied) will encounter issues when running on Windows Server 2016. Customers are advised to contact support, should they encounter any issues with SSMS on Windows Server 2016. Support will then work with customers to determine if the issue is with SSMS or Visual Studio or with Windows compatibility, and route the issue appropriately.
SSMS 18.x is based on the new Visual Studio 2017 Isolated Shell: The new shell unlocks all the accessibility fixes that went in to both SSMS and Visual Studio.
SQL Server Management Studio 18.9.2 GA: Chinese (People's Republic of China) | Chinese (Taiwan) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
- GA - General Availability
- PP - Public Preview
- Size in Megabytes for English version
| Version/Download Link | Info | Build | Release Date | Size, Mb |
|---|---|---|---|---|
| 18.9.2 GA Release | Latest GA | 15.0.18386.0 | 2021-07-15 | 642 |
| 18.9.1 GA Release | 15.0.18384.0 | 2021-04-20 | 635 | |
| 18.9 GA Release | 15.0.18382.0 | 2021-04-15 | 635 | |
| 18.8 GA Release | 15.0.18369.0 | 2020-12-17 | 640 | |
| 18.7.1 GA Release | 15.0.18358.0 | 2020-10-27 | 635 | |
| 18.7 GA Release | 15.0.18357.0 | 2020-10-20 | 635 | |
| 18.6 GA Release | 15.0.18338.0 | 2020-07-22 | 534 | |
| 18.5.1 GA Release | 15.0.18333.0 | 2020-06-09 | 535 | |
| 18.5 GA Release | 15.0.18183.0 | 2020-04-07 | 535 | |
| 18.4 GA Release | 15.0.18206.0 | 2019-11-04 | 539 | |
| 18.3.1 GA Release | 15.0.18183.0 | 2019-10-02 | 534 | |
| 18.3 GA Release | 15.0.18178.0 | 2019-09-23 | 534 | |
| 18.2 GA Release | 15.0.18142.0 | 2019-07-25 | 528 | |
| 18.1 GA Release | 15.0.18131.0 | 2019-06-11 | 527 | |
| 18.0 GA Release | 15.0.18118.0 | 2019-04-24 | 524 | |
| 18.0 RC1 Release | 15.0.18098.0 | 2019-03-28 | 484 | |
| 18.0 Preview 7 Release | 15.0.18092.0 | 2019-03-01 | 478 | |
| 18.0 Preview 6 Release | 15.0.18075.0 | 2018-12-18 | 457 | |
| 18.0 Preview 5 Release | 15.0.18068.0 | 2018-11-15 | 457 | |
| 18.0 Preview 4 Release | 15.0.18040.0 | 2018-09-24 | 456 | |
| 17.9.1 Release | Latest 17 | 14.0.17289.0 | 2018-11-21 | 807 |
| 17.9 Release | 14.0.17285.0 | 2018-09-04 | 807 | |
| 17.8.1 Release | 14.0.17277.0 | 2018-06-26 | 806 | |
| 17.8 Release | Deprecated | 14.0.17276.0 | 2018-06-21 | 806 |
| 17.7 Release | 14.0.17254.0 | 2018-05-09 | 803 | |
| 17.6 Release | 14.0.17230.0 | 2018-03-20 | 802 | |
| 17.5 Release | 14.0.17224.0 | 2018-02-15 | 802 | |
| 17.4 Release | 14.0.17213.0 | 2017-12-07 | 802 | |
| 17.3 Release | 14.0.17199.0 | 2017-10-09 | 801 | |
| 17.2 Release | 14.0.17177.0 | 2017-08-07 | 819 | |
| 17.1 Release | 14.0.17119.0 | 2017-05-24 | 784 | |
| 17.0 Release | 14.0.17099.0 | 2017-04-25 | 729 | |
| 17.0 RC3 Release | 14.0.17028.0 | 2017-03-09 | 677 | |
| 17.0 RC2 Release | 14.0.16150.0 | 2017-02-01 | 682 | |
| 17.0 RC1 Release | 14.0.16000.64 | 2016-11-16 | 687 | |
| 16.5.3 Release | Latest 16 | 13.0.16106.4 | 2017-01-26 | 898 |
| 16.5.2 Release | Deprecated | 13.0.16105.4 | 2017-01-18 | 898 |
| 16.5.1 Release | 13.0.16100.1 | 2016-12-05 | 894 | |
| 16.5 Release | 13.0.16000.28 | 2016-10-26 | 894 | |
| 16.4.1 Release | 13.0.15900.1 | 2016-09-23 | 894 | |
| 16.4 Release | Deprecated | 13.0.15800.18 | 2016-09-20 | |
| 16.3 Release | 13.0.15700.28 | 2016-08-15 | 806 | |
| July 2016 Hotfix Update | 13.0.15600.2 | 2016-07-13 | 825 | |
| July 2016 Release | Deprecated | 13.0.15500.91 | 2016-07-01 | |
| June 2016 Release | 13.0.15000.23 | 2016-06-01 | 825 | |
| SQL Server 2014 SP1 | 12.0.4100.1 | 2015-05-14 | 815 | |
| SQL Server 2012 SP3 | 11.0.6020.0 | 2015-11-21 | 964 | |
| SQL Server 2008 R2 | 10.50.4000 | 2012-07-02 | 161 |