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.
 
Getting Started With SQL Server 2019 
 
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.
 
Getting Started With SQL Server 2019 
 
After opening SQL Server Management Studio 2018, we can see it looks like the below screenshot.
 
Getting Started With SQL Server 2019 
 
Step 4
 
Now connect to the server and use the SQL Server Management Studio 2019. Click the Connect button to connect the SQL Server.
 
Getting Started With SQL Server 2019 
 
Step 5
 
If the connection is established successfully, then you will see the Object Explorer panel,
 
Getting Started With SQL Server 2019 
 
Execute a query
 
Now click on New Query, to open your new query window.
 
Getting Started With SQL Server 2019 
 
New query window.
 
Getting Started With SQL Server 2019 
 
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. 
  1. 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.
 
Getting Started With SQL Server 2019 
 
We can check now if the database is created or not.
 
Getting Started With SQL Server 2019 
 
Our database is created.
 
Step 2 - Create a table
 
Open your SQL Server and use the following script to create table “tbl_Employees”.
  1. Create table tbl_Employees    
  2.  (   
  3.    Id int primary key not null identity(1,1),   
  4.    FirstName varchar(50),   
  5.    LastName varchar(20),   
  6.    Location varchar(20),   
  7.    Gender varchar(50),   
  8.    Salary int   
  9.  )   
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.
  1. Insert into tbl_Employees values ('Chittaranjan''Swain','Odisha''Male', 80000)   
  2. Insert into tbl_Employees values ('Chandin''Swain''Pune','Female', 76000)   
  3. Insert into tbl_Employees values ('Mitu''Pradhan','Delhi''Male', 55000)   
  4. Insert into tbl_Employees values ('Jeni''Swain','Chennai''Female', 76000)   
  5. Insert into tbl_Employees values ('Adyashree''Swain','UK''Female', 49000)   
  6. Insert into tbl_Employees values ('Ram''Kumar','US''Male', 39000)   
  7. Insert into tbl_Employees values ('Jitendra''Gouad','Hydrabad''Male', 35000)   
  8. 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.
  1. select * from tbl_Employees    
Output
 
Getting Started With SQL Server 2019 
 

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.