What is 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 all components of SQL Server, Azure SQL Database, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich scripts editors to provide access to SQL Server for developers and database administrators of all skill levels
SQL Server Management Studio for Business Intelligence
To access, configure, manage, and administer Analysis Services, Integration Services, and Reporting Services use SQL Server Management Studio. Although all three business intelligence technologies rely on SQL Server Management Studio, the administrative tasks associated with each of these technologies are slightly different.
· Note
To create and modify Analysis Services, Reporting Services, and Integration Services solutions, use SQL Server Data Tools (SSDT), not SQL Server Management Studio. SQL Server Data Tools (SSDT) is a development environment that is based on Microsoft Visual Studio.
