Pages

25 February 2019

What is Database || What is SSMS || Connecting to SQL Server Management Studio

What is Database ?

A database is a collection of information or an organized collection of data which is generally stored and accessed  electronically from a computer system or we can say, A database is a collection of tables and database objects like store procedures,view,functions etc.

What is SQL Server Management Studio (SSMS) ?

SQL Server management studio is an software application which allows you to create and manage your database. Many people stay confused with it.
but let me tell you SQL Server Management Studio is  a client tool and not a database by itself and it use to interact with the database server.



As you can see above,there is a centralized database server and with that there are 4 Clients connect using SSMS.

Different Authentication Method that use to connect to SSMS ?





No comments: