SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop platforms that use the Microsoft SQL Database Engine, including SQL Server, Azure SQL DatabaseSQL database in Microsoft FabricAzure SQL Managed InstanceSQL Server on Azure Virtual Machines, and others.

What you can do with SSMS : SSMS brings together graphical tools and rich editors to help you:
  • Connect securely to SQL Server, Azure SQL, and related services. Manage objects by using Object Explorer and design tools.
  • Query, script, and tune workloads by using the Query Editor, execution plans, and built-in performance tools.
  • Administer business intelligence features such as Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).

Technical Details