How to Install Microsoft SQL Server 2016

Among fresher's and developer, Installation of SQL Server is considered as complex task. This can become easiest if you follow instructions carefully
 

I am going to install MS SQL server 2016 Express edition with service pack 1 as its freely available

1. Download software from https://www.microsoft.com/en-us/sql-server/sql-server-downloads

  2. I have downloaded file "SQLServer2016-SSEI-Expr.exe"  

  3. Now right click on file, run as administrator, Select basic

4. Scroll and accept license

5. Select installation location and click install, I am using default location

6. This will download original software and install

7. instance name is SQLEXPESS

No we will go ahead and install SSMS (This is required, If you want to connect to sql server and run some sql queries)

1. Click on Install SSMS button in above screen

His will take you on another scree to download files for SSMS (Sql server management studio)

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

2. Once Sql server is downloaded, you can open folder and start installation

3. Click install to install SSMS

4. Once SSMS installed, Restart your machine

5. After SQL Server restart you can go to start menu or desktop and search for SQL Server management studio

6. Type servername : yourmachinename\SQLexpress, if you are not aware of your machine name , right click on my computer and check properties

7. Once you are connect , Press ctrl +N à New Query window and type below code to create database dummy and enter few records in same.

Create database dummy

go

use dummy

Go

Create table emp(id int, name varchar(30), age int)

go

insert into emp values (1, 'saurabh', 30)

go

insert into emp values (2, 'vinod', 31)

go

select * from emp

Install SQL server 2019: