Skip to content

Latest commit

 

History

History
110 lines (83 loc) · 7 KB

installation.md

File metadata and controls

110 lines (83 loc) · 7 KB

Databases II - Workshops

Installation Guide

To start any workshop, you need atleast all the required software and required databases.

Windows Users

Follow the steps sequentially to get started.

  1. SQL Server 2017
  2. SQL Server Management Studio (SSMS)
  3. SQL Server Data Tools (SSDT)
  4. Databases

The following software is not required but can be useful.

MAC | Apple Users

If you're a MAC or Apple user, we recommend using a VM or another way to run Windows on your device. However you can also follow this unsupported guide, which will install SQL Server 2017(step 1) in a docker container. As an alternative client for step 2 we recommend Azure Data Studio. Afterwards install the required databases (step 4).

Note that we do not support this setup and have no alternative for step 3 (SSDT).

Required Software

SQL Server 2017

Download

In the workshops you require the "Enterprise Edition" of SQL Server, which is a paid licence. The licenced installer can be downloaded through this secured link on Chamillo.

Installation

  1. Mount the .iso file and open the setup.exe

  2. Click installation install-sql-server-1

  3. Click new SQL Server stand-alone installation... install-sql-server-2

  4. Click next a few times and agree to the license terms.

  5. Make sure the following features are selected and click next.

    • Database Engine Services

      REMARK: If you already have a Database Engine installed (by following another course e.g. Web Applications 3), you must leave this feature unchecked.

    • Integration Services

    install-sql-server-3

  6. Leave the default instance and click next. install-sql-server-4

  7. Click next when asked about service accounts.

  8. Make sure:

    • Windows Authentication Mode is checked
    • Click the button Add Current User to add yourself as SQL Administrator

    install-sql-server-5

  9. Finally, click Install.

SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts.

Use SSMS to query, design, and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud. Learn More.

Installation
  1. Download the installer.
  2. Install using the default setup.

Sql Server Data Tools (SSDT)

SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, Azure SQL Databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio. Learn More

Installation

There are subtle differences between Visual Studio 2017 and 2019, use the correct installation guide:

  • Visual Studio 2017
    • Additionally install the Integration Services by using the stand-alone installer which can be found here
  • Visual Studio 2019
    • Additionally install the Integration Services by installing the extension which can be found here.

Required Databases

There are multiple databases required for the workshops. You'll be restoring the databases on your freshly installed SQL Server by following the steps below.

  1. Download the following databases:

  2. Copy all the databases above to the C:\Temp folder, if the folder does not exist, create it.

    Remark: do not skip this step.

  3. Open SQL Server Management Studio and connect to localhost.

    install-databases-1

  4. Right click Databases in the object explorer and select Restore Database....

    install-databases-2

  5. Select Device and press the ... button

    install-databases-3

  6. Click Add

    install-databases-4

  7. Locate the C:\Temp folder and click it, select a database.bak file, click OK.

    install-databases-5

  8. Click OK

  9. Repeat step 3-7 for every database mentioned above.

Optional Software

Azure Data Studio

Previously released under the name of SQL Operations Studio, Azure Data Studio offers a modern editor experience for managing data across multiple sources with fast intellisense, code snippets, source control integration, and an integrated terminal. Azure Data Studio is engineered with the data platform user in mind, with built-in charting of query result-sets and customizable dashboards.

Azure Data Studio is complementary to SQL Server Management Studio with experiences around query editing and data development, while SQL Server Management Studio still offers the broadest range of administrative functions, and remains the flagship tool for platform management tasks.

Azure Data Studio will continue to be updated on a monthly basis and currently offers built-in support for SQL Server on-premises and Azure SQL Database, along with preview support for Azure SQL Managed Instance, Azure SQL Data Warehouse, and SQL Server 2019 Big Data. Learn More