Introduction
This guide provides an integral tutorial to install Microsoft SQL Server in the Windows operating system.
Cover the necessary steps to configure SQL Server, install SQL Server Database Management Studio (DBMS) and configure popular sampling databases such as Adventureworks and Wideworldimporters.
ALTHEGH The described procedures are designed for the 2019 version, are compatible with the versions published after 2019.
Therefore, this guide is a versatile resource to configure SQL Server environments in newer editions as well.
Phase 1: SQL Server installation
- Once the file has finished downloading, double click on it to start the installation.
- In the window that appears, choose the type of “basic” installation.
- Press “Next”, accept the terms and conditions, and then click “Inst.”
- Once the installation is finished, you will receive a link to download SQL Server Management Studio. If you do not see the link, click this provid link: https://aka.ms/ssmsfullsetupup
- Download SQL Server Management Studio and Proan to install it.
Phase 2: Adventureworks (2019 or 2022) Database
- After the SQL Server 2019 successful installation, you will need a database for practice. Follow the following link to download the Adventureworks2019 or 2022 database:
https://github.com/microsoft/sql-server-samples/releases/tag/adventureworks
- On the website, locate and select the option highlighted to download the Adventureworks2019. File Archive or Adventureworks2022.bak File.
- Navigate to the folder where Adventureworks2012. The file file has been downloaded and processed to make a copy of the file.
- Paste the file in the backup folder within its newly installed SQL system, which must be placed in a location that resembles which is described below:
C: \ Program files \ Microsoft Sql Server \ mssql11.sqlserverbi \ mssql \ backup
- Then, Abra SQL Server Management Studio from the program menu or the application desktop (Windows 8).
Phase 3: Adventureworks Data Warehouse
- After downloading the file, following similar steps that in Phase 2 To restore the database.
Phase 4: Wideworldimporters database
- Be sure to follow the steps as described in phase 2 to restore the database.
Conclude
This guide has detailed the application for steps to install SQL Server 2019, configure SQL Server Management Studio and configure several sampling databases, including Adventureworks and Wideworldimporters.
Following these instructions, users can quickly establish a functional SQL Server environment for development and test purposes.
Although the approach has been in SQL Server 2019, the procedures are also applicable to subsequent versions, which guarantees that the guide remains relevant to users who work more recently from SQL Server.
