Microsoft SQL Server is a database system that comprises many components, including the Database Engine, Analysis Services, Reporting Services, SQL Server Graph Databases, SQL Server Machine Learning Services, and several other components.
SQL Server 2019 has a lot of new features:
- Intelligence across all your data with Big Data Clusters
- Choice of language and platform
- Industry-leading performance
- Most secured data platform
- Unparalleled high availability
- End-to-end mobile BI
- SQL Server on Azure
Download SQL Server 2019
Step 2 :To download the installer you need to fill a short form and provide your contact information.
Run the installer
Step 3 :After the download completes, run the downloaded file. Select Basic installation type.
Step 4 :Select ACCEPT to accept the license terms.
Step 5 :Accept the install location, and click INSTALL.
Step 6 :When the download completes, installation will automatically begin.
Step 7 :After installation completes, select CLOSE.
Step 8 :After this has completed, you will have SQL Server 2019 Installation Center installed.
Install SQL Server Management Studio
The steps for installing SQL Server Management Studio are as follows:
Step 9 :Open the SQL Server 2019 Installation Center application
Step 10 :Select installation on the left pane, then install SQL Server Management tools.
Step 11 :Select Download SQL Server Management Studio (SSMS).
Step 12 :After the download completes, click RUN
Step 13 :Then INSTALL
Step 14 :When installation completes, click CLOSE.
Step 15 :After this has completed, you will have several new software apps installed, including SQL Server Management Studio.
Use SQL Server Management Studio
Step 16 :When you open the SQL Server Management Studio application, you’ll first see a Connect to Server window. This window allows you to establish a connection with the SQL Server instance that you already installed. The Server Name will show instance you installed, and the Authentication will show Windows Authentication. The Server Type is Database Engine.
Step 17 :Click the CONNECT button.