What is Microsoft SQL Server Management Studio and what is it good for?
Experience Level: Junior
Tags: DatabasesQuality Assurance (QA)
Answer
Microsoft SQL Server Management Studio (SSMS) is a client application for Microsoft SQL Server.
The SSMS is installed on your client computer. For that reason we say the SSMS is Client application.
On contrary the Microsoft SQL Server is installed on a server. We say the SQL Server is a Server application.
You can use SSMS (client application) to connect to SQL Server (server application) and after the connection is established, you can manipulate the SQL Server remotely using SSMS.
Using the SSMS you can:
- Connect to SQL Server
- See what databases are stored on SQL Server and manage them
- Manage data stored in SQL Server
- Manage tables in databases that are stored on SQL Server
- Run queries against SQL Server
- Manage SQL Server settings
Related Databases job interview questions
How would you run SSMS (Microsoft SQL Server Management Studio)?
DatabasesQuality Assurance (QA) JuniorWhat is SSMS?
DatabasesQuality Assurance (QA) JuniorWhat is a difference between DROP TABLE and TRUNCATE TABLE and DELETE FROM?
Databases MediorWhat will be the result of the following T-SQL?
Code challengeDatabasesMS SQL ServerSQL SeniorWhat is the difference between OLAP and OLTP? When is each used?
Databases Medior
