Skip to content

Latest commit

 

History

History
33 lines (18 loc) · 1.79 KB

TechJam_DW_StartetKit.md

File metadata and controls

33 lines (18 loc) · 1.79 KB

Starter Kit and Resources for Tech Jam: From an Operational Database to a Data Warehouse

Required Setup

  • Microsoft SQL Server Developer Edition
  • Microsoft SQL Server Management Studio
  • Microsoft Power BI

Microsoft SQL Server Developer Edition

For Windows, download the latest version of MSSQL Server Developer edition. This is free software and requires no registration.

Execute the SQL2019-SSEI-Dev.exe, choose Download Media at a specified location

Use ISO packaging, mount and install

After checking your computer, make full installation, select all options and proceed using default settings

Add current user in all cases

For authentication, choose mixed mode authentication (it may be shown as SQL Server and Windows Authentication mode). If you are asked for a user name, use sa, and for the password use passw0rd (we will only use publicly available sample data for the project so we are ok with basic security)

SQL Server Management Studio

For Windows, download the latest version of MSSQL Server Management Studio. This is free software and requires no registration.

Once it is installed, run it and it will connect to the SQL Server that you installed in the previous step

For authentication, choose SQL server authentication, and enter the user name and password which you created in the previous step for the SQL Server

Microsoft Power BI

Download Power BI Desktop and install the PBIDesktopSetup_x64.exe or download it from the Windows Store