| title | SQL Server Management Studio | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 06/13/2017 |
| ms.prod | sql-server-2014 |
| ms.reviewer | |
| ms.technology | ssms |
| ms.topic | conceptual |
| ms.assetid | 66a6b7b1-de6a-4161-82bd-98ded486947b |
| author | stevestein |
| ms.author | sstein |
| manager | craigg |
[!INCLUDEssManStudioFull] is an integrated environment for managing your SQL Server infrastructure. [!INCLUDEssManStudio] 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.
[!INCLUDEssManStudioFull] is a comprehensive utility for managing SQL Server objects that combines an easy-to-use graphical interface with rich scripting capabilities. [!INCLUDEssManStudio] can be used to manage [!INCLUDEssDE], [!INCLUDEssASnoversion], [!INCLUDEssISnoversion], and [!INCLUDEssRSnoversion].
| Description | Topic |
|---|---|
| Describes common tasks performed by using [!INCLUDEssManStudio], such as customizing keyboard shortcuts and viewing property pages. | Use SQL Server Management Studio |
| Describes using Object Explorer to view and manage all of the objects in one or more instances of [!INCLUDEssNoVersion]. | Object Explorer |
| Describes 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 |
| Describes how to use the deprecated Solution Explorer to build projects used to manage administration items such as scripts and queries. | Solution Explorer |
| Describes how to connect [!INCLUDEssManStudio] to instances of the [!INCLUDEssDE] and [!INCLUDEssASnoversion]. | F1 Help for Server Connections (SQL Server Management Studio) |
| Describes how to use the visual design tools included in [!INCLUDEssManStudio]. | Visual Database Tools |
| Describes how to use the [!INCLUDEssManStudio] language editors to interactively build and debug queries and scripts. | Query and Text Editors (SQL Server Management Studio) |
Tutorial: SQL Server Management Studio
Tutorial: Writing Transact-SQL Statements