Part 1 What is SQL Server

Sql server and database are two different things.

Sql server management studio is a client tool which is use to do operations on database  with commands terms as queries. SSMS is not a database.

 all table, views, triggers are created by SSMS and stored on one database.

SSMS give us flexibility of multi-user operate single database environment.

 

Connecting to Sql server 2008

Start -> All Programs -> Microsoft SQL Server 2008 -> SQL Server Management Studio

a connecting window shows up

first you  see  server type. There are different server type shown in dropdown list. select Database Engine, we'll talk other types later

server name 

If you have the multiple user environment shown in figure 1 above set the server name as your pc name or your pc IP address. 

In my case I can select my local pc name as (local) or . or IP

Authentication 

there are two type of authorizations Windows authentication and Sql Server  authentication 

these type are depends on How you install sql server. If you install mix mode both type are shown, if you sql server only Sql Server  authentication 

If you select Sql Server  authentication you need to give username and password where as if you select Windows authentication Windows authentication there is no need of giving username and password and click connect 

the instance of sql server is created and connect 

after connecting  this screen is shown. To write a query click New Query button a query editing window generated. In next session we write query and create user define database.