SQL Server Management Studio (SSMS)

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.

SQL Server Management Studio components

Description Component
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)

Next steps

Tutorial: SQL Server Management Studio
Tutorial: Writing Transact-SQL Statements