Getting Started With SQL Server 2019

Introduction

 

In this article, I am going to explain how to connect to SQL Server from the SQL Server Management Studio after installing SQL Server 2019 and executing a query, and talk about what’s new in SQL Server 2019, which is the latest version.

 

Read my previous article,  “How To Install SQL Server 2019”, before reading this article. It talks about   how to download and install SQL Server 2019 Developer Edition.

 

Prerequisites

1. SQL Server 2019

What's new in SQL Server 2019?

 

Features

• Data virtualization and SQL Server 2019 Big Data Clusters
• Intelligent Database
• Intelligent Query Processing
• In-Memory Database
• In-Memory Database
• Monitoring
• Developer experience
• Graph
• Unicode support
• Language extensions
• Spatial
• Error messages
• Mission-critical security
• High availability
• Availability Groups
• Recovery
• Resumable operations
• Platform choice
• Linux
• Containers
• Setup options
• SQL Server Machine Learning Services
• SQL Server Analysis Services
• SQL Server Integration Services
• SQL Server Master Data Services
• SQL Server Reporting Services

To get more details about what’s new in SQL Server 2019 Click here.

 

Connect To The SQL Server Using SQL Server Management Studio 2019 (SSMS)

 

To connect SQL Server 2019 using the Microsoft SQL Server Management Studio 2019, you use these steps,

 

Step 1

 

First, install SQL Server 2019 in your system.

 

Step 2

 

Go to all programs in your systems, we can see two folders one is Microsoft SQL Server 2019 and another one is Microsoft SQL Server Tool 2018. Under Microsoft SQL Server Tools 18 you can see the Microsoft SQL Server Management Studio 18.

 

 

 

Step 3

 

Double-click on SQL Server Management Studio 18 and it will open. It looks like the below screenshot. Opening it the first time it will take a few minutes.

 

 

 

After opening SQL Server Management Studio 2018, we can see it looks like the below screenshot.

 

 

 

Step 4

 

Now connect to the server and use the SQL Server Management Studio 2019. Click the Connect button to connect the SQL Server.

 

 

 

Step 5

 

If the connection is established successfully, then you will see the Object Explorer panel,

 

 

 

Execute a query

 

Now click on New Query, to open your new query window.

 

 

 

New query window.

 

 

 

Now, first we will create a Database and a table.

 

Creating Database and One Table

 

Step 1 - Create a Database

 

Open your SQL Server and use the following script to create the “Chittadb” Database. 

create database Chittadb

Now, select the script query then press F5 or click on Execute button to execute the above script.

 

You should see a message, “Command(s) completed successfully.” Means your new database is created.

 

 

 

We can check now if the database is created or not.

 

 

 

Our database is created.

 

Step 2 - Create a table

 

Open your SQL Server and use the following script to create table “tbl_Employees”.

Create table tbl_Employees
 (
   Id int primary key not null identity(1,1),
   FirstName varchar(50),
   LastName varchar(20),
   Location varchar(20),
   Gender varchar(50),
   Salary int
 )

Execute the above query to create “tbl_Employees “.

 

You should see a message, “Command(s) completed successfully” with completion time. 

 

Now, data is inserted into the table.

Insert into tbl_Employees values ('Chittaranjan', 'Swain','Odisha', 'Male', 80000)
Insert into tbl_Employees values ('Chandin', 'Swain', 'Pune','Female', 76000)
Insert into tbl_Employees values ('Mitu', 'Pradhan','Delhi', 'Male', 55000)
Insert into tbl_Employees values ('Jeni', 'Swain','Chennai', 'Female', 76000)
Insert into tbl_Employees values ('Adyashree', 'Swain','UK', 'Female', 49000)
Insert into tbl_Employees values ('Ram', 'Kumar','US', 'Male', 39000)
Insert into tbl_Employees values ('Jitendra', 'Gouad','Hydrabad', 'Male', 35000)
Insert into tbl_Employees values ('Dibas', 'Hembram','Bangalore', 'Male', 55000)

Execute the above query, you should see a message, “Command(s) completed successfully.”

 

Now retrieve all data from “tbl_Employees” table.

select * from tbl_Employees

Output

 

 

 

Conclusion

 

In this article we explained how to connect SQL Server and execute a query from the SQL Server Management Studio 2019 (SSMS) and how to create a database and a table.