SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL from wherever you deploy it. SSMS 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.
SSMS is part of a suite of developer tools Microsoft offers free of charge for your development needs.
- Download SQL Server Management Studio (SSMS)
- Download SQL Server 2016 Developer edition
- Download Visual Studio 2015 Developer edition
SQL Server Management Studio components
|Common tasks performed by using Management Studio, such as customizing keyboard shortcuts and viewing property pages.||Use SQL Server Management Studio|
|Use Object Explorer to view and manage all of the objects in one or more instances of SQL Server.||Object Explorer|
|How to use Template Explorer to build and manage files of boilerplate text that can be used to speed the development of queries and scripts.||Template Explorer|
|How to use the deprecated Solution Explorer to build projects used to manage administration items such as scripts and queries.||Solution Explorer|
|How to connect Management Studio to instances of the Database Engine and Analysis Services.||F1 Help for Server Connections (SQL Server Management Studio)|
|How to use the visual design tools included in Management Studio.||Visual Database Tools|
|How to use the Management Studio language editors to interactively build and debug queries and scripts.||Code and Text Editors (SQL Server Management Studio)|