SQL Server Management Studio

SaaS

SQL Server Management Studio (SSMS) is Microsoft's environment for configuring, administering and developing SQL Server and Azure SQL databases.

learn.microsoft.com
SQL Server Management Studio homepage screenshot

About SQL Server Management Studio

SQL Server Management Studio is described by Microsoft as an integrated environment for managing any SQL infrastructure. It is used to access, configure, manage, administer and develop all components of the Database Engine.

The current release, SSMS 22, works with SQL Server 2014 (12.x) and later, plus Azure SQL Database, Azure SQL Managed Instance, Azure Synapse Analytics and SQL database in Microsoft Fabric. Older server versions are handled through the release history, which lets you install a specific SSMS version.

SSMS 22 installs through the Visual Studio Installer. The download link fetches a small stub installer, vs_SSMS.exe, that launches the installer; updates go through the same route, and an offline layout can be created for disconnected or managed installs. A command-line install is also documented.

Key features

  • Integrated environment for managing SQL infrastructure
  • Access, configure and develop Database Engine components
  • Supports SQL Server 2014 and later
  • Works with several Azure and Fabric SQL services
  • Offline layouts for disconnected or managed installs
  • Scripted command-line installation

Good fit for

  • Administering the Database Engine
  • Developing against Azure SQL
  • Scripted or offline enterprise deployment
Tags
sql server
database management
microsoft
azure sql
ssms
administration

SQL Server Management Studio: questions and answers

What is SQL Server Management Studio used for?
SQL Server Management Studio (SSMS) is Microsoft's environment for configuring, administering and developing SQL Server and Azure SQL databases. It is a good fit for administering the Database Engine, developing against Azure SQL and scripted or offline enterprise deployment.
Is SQL Server Management Studio free?
Yes. SQL Server Management Studio is free to use.
Is SQL Server Management Studio open source?
No. SQL Server Management Studio is proprietary (closed-source) software. Open-source alternatives to SQL Server Management Studio include Dbx, DBeaver and Beekeeper Studio.
What are some alternatives to SQL Server Management Studio?
SQL Server Management Studio competes with DataGrip, dbForge Studio and Navicat. For open-source options, see Enlisted's ranked list of open-source SQL Server Management Studio alternatives.

Open-source alternatives to SQL Server Management Studio

See all

SaaS alternatives to SQL Server Management Studio

See all