Friday, June 4, 2021

SQL Server Management Studio (SSMS)


SQL Server Management Studio (SSMS) provides a unified management environment for any SQL system. All components of SQL Server, Azure SQL Database, and Azure Synapse Analytics may be accessed, configured, managed, administered, and developed using SSMS. SSMS is a single, comprehensive application that combines a wide range of graphical tools with a variety of rich script editors to provide you access to SQL Server.


Mainly there are 5 Components in SQL Server Management Studio

>  Object Explorer

Object Explorer allows you to see and manage all of the objects in one or more SQL Server instances. 

> Template Explorer    

How to utilize Template Explorer to create and maintain boilerplate text that you may use to speed up query and script development. 

> Solution Explorer

How to create projects using the deprecated Solution Explorer to manage administration elements like scripts and queries.

> Visual Database Tools

How to make use of Management Studio's visual design capabilities.

> Query and Text Editors

How to use the Management Studio language editors to interactively build and debug queries and scripts.




No comments: