Image by Freepik

Comprehensive guide to installing Microsoft SQL server

ByAdmin

Introduction

This guide provides a comprehensive walkthrough for installing Microsoft SQL Server on Windows operating system.

It covers the necessary steps to set up SQL Server, install SQL Server Database Management Studio (DBMS), and configure popular sample databases such as AdventureWorks and WideWorldImporters.

Although the procedures outlined are tailored for the 2019 version, they are compatible with versions released after 2019.

Thus, this guide is a versatile resource for setting up SQL Server environments in newer editions as well.

Phase 1: Installing SQL Server

A screenshot of a computer Description automatically generated

  • After the file has finished downloading, double-click on it to initiate the installation.
  • In the window that appears, choose the “Basic” installation type.
A screenshot of a software version Description automatically generated

  • Press “Next,” agree to the Terms and Conditions, and then click “Install.”
  • After the installation is finished, you will receive a link to download SQL Server Management Studio. If you don’t spot the link, please click on this provided link: https://aka.ms/ssmsfullsetup
  • Download SQL Server Management Studio and proceed to install it.

Phase 2: AdventureWorks (2019 or 2022) database

  • Upon the successful installation of SQL Server 2019, you’ll require a database for practice. Please follow the link below to download the AdventureWorks2019 or 2022 Database:

    https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks

    • On the webpage, locate and select the highlighted option to download the AdventureWorks2019.bak file or AdventureWorks2022.bak file.
      A screenshot of a computer Description automatically generated

      • Navigate to the folder where the AdventureWorks2012.bak file has been downloaded and proceed to make a copy of the file.
      • Paste the file into the Backup folder within your freshly installed SQL system, which should be situated in a location resembling the one described below:

        C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVERBI\MSSQL\Backup

        • Next, open SQL Server Management Studio from either the Programs Menu or the Applications Desktop (Windows 8).

          Phase 3: AdventureWorks data warehouse

          • After downloading the file, following similar steps as in Phase 2 to restore the database.
            A screenshot of a data warehouse Description automatically generated

            Phase 4: WideWorldImporters database

            • Ensure to following the steps as outlined in Phase 2 to restore the database.
              A screenshot of a computer Description automatically generated

              Wrapping up

              This guide has detailed the steps required to install SQL Server 2019, set up SQL Server Management Studio, and configure various sample databases including AdventureWorks and WideWorldImporters.

              By following these instructions, users can quickly establish a functional SQL Server environment for development and testing purposes.

              While the focus has been on SQL Server 2019, the procedures are also applicable to later versions, ensuring that this guide remains relevant for users working with more recent releases of SQL Server.

              Similar Posts

              Bank deposit - feature image

              Predicting bank deposit subscriptions using machine learning

              ByAdmin

              Introduction The ability to predict customer behaviour has become increasingly important for businesses, especially in the financial sector. For banks, understanding which clients are likely to subscribe to a term deposit can lead to more effective marketing strategies and better resource allocation. This analysis explores a beginner’s approach to predicting whether a client will subscribe…

              Call centre Feature Image

              How to analyse call-centre-sentiments data using Python

              ByAdmin

              Introduction Customer service quality can make or break a company’s reputation. Call-centres are often at the frontline of customer interactions, making them a crucial component of customer satisfaction strategies. To ensure that these interactions meet customer expectations, it’s essential to analyse and understand the factors that contribute to positive or negative experiences. In this project,…

              Income-levels-Feature-Image

              How to predict income levels using machine learning

              ByAdmin

              Introduction The ability to extract meaningful insights from raw data is more crucial now than ever. Among the many datasets available for analysis, the “Adult Census Income” data can be used to understand the socio-economic factors that influence income levels. This dataset, collected from the 1994 U.S. Census, includes a variety of demographic information, such…

              Heart-disease-feature-image

              How to predict heart disease treatment using Python

              ByAdmin

              Introduction Heart disease remains one of the leading causes of morbidity and mortality worldwide. Hence, understanding the factors that contribute to heart disease and the treatments that can mitigate its effects is crucial for improving patient outcomes. This project will explore a dataset related to heart attack patients and analyse various demographic, lifestyle, and clinical…

              Feature Image

              Predictive modeling for assessing automobile insurance risks

              ByAdmin

              Introduction The automobile industry has always been at the forefront of innovation, constantly seeking ways to improve efficiency, safety, and customer satisfaction. Predictive modeling adds a new dimension to this effort by enabling data-driven decisions that benefit manufacturers, insurers, and consumers. In this project, we focus on predicting normalised losses for vehicles, a crucial metric…