SQL Server Management Studio
Earlier version of Microsoft SQL Server Management Studio showing a query, the results of the query, and the Object Explorer pane while connected to a SQL Server database engine instance. | |
Developer(s) | Microsoft |
---|---|
Initial release | 2005 |
Stable release | 18.10[1]
/ October 5, 2021 |
Operating system | Microsoft Windows |
Available in | Chinese (Simplified), Chinese (Traditional), English (United States), French, German, Italian, Japanese, Korean, Portuguese (Brazil), Russian, Spanish |
Website | docs.microsoft.com/en-us/sql/ssms |
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. It is the successor to the Enterprise Manager in SQL 2000 or before. The tool includes both script editors and graphical tools which work with objects and features of the server.[2]
SSMS is one of the SQL Server management tools, regardless of your location, used for designing queries and managing databases and data warehouses via personal computer or Cloud.[3]
In reality, SSMS is an integrated environment that provides tools for configuring, monitoring, and administering SQL Server instances and databases.[4]
A central feature of SSMS is the Object Explorer, which allows the user to browse, select, and act upon any of the objects within the server.[5] It also shipped a separate Express edition that could be freely downloaded, however recent versions of SSMS are fully capable of connecting to and manage any SQL Server Express instance. Microsoft also incorporated backwards compatibility for older versions of SQL Server thus allowing a newer version of SSMS to connect to older versions of SQL Server instances. It also comes with Microsoft SQL Server Express 2012, or users can download it separately.
Starting from version 11, the application was based on the Visual Studio 2010 shell, using WPF for the user interface. Versions 18 and after are based on the Visual Studio 2017 Isolated Shell.[6]
In June 2015, Microsoft announced their intention to release future versions of SSMS independently of SQL Server database engine releases.[7]
See also[]
- Comparison of database tools
- Microsoft SQL Server
- SQL Server Management Objects
References[]
- ^ "Download SQL Server Management Studio (SSMS)". 5 October 2021.
- ^ MSDN: Introducing SQL Server Management Studio
- ^ "SQL Server Management Studio (SSMS): The Definitive Guide (2022)". Nill2Bill. 2021-12-24. Retrieved 2021-12-24.
- ^ "SQL Server Management Studio (SSMS): The Definitive Guide (2022)". Nill2Bill. 2021-12-24. Retrieved 2021-12-24.
- ^ MSDN: Using Object Explorer
- ^ "SSMS 18.0 (preview 4)". SQL Server Management Studio - Changelog (SSMS). Microsoft. 24 September 2018. Retrieved 22 October 2018.
- ^ "Announcing SQL Server Management Studio – June 2015 Release". SQL Release Services Blog. Microsoft. 24 June 2015. Retrieved 7 September 2015.
External links[]
- Microsoft database software
- Database administration tools
- Microsoft software stubs