Have you failed a job interview?
Send us your job interview questions and get correct answers.

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

Comments

No Comments Yet.
Be the first to tell us what you think.
MS SQL Server for Testers
MS SQL Server for Testers

Are you learning Databases ? Try our test we designed to help you progress faster.

Test yourself