Welcome to Wide World Importers JP Voogt Cloudy

Objective We will cover what Wide. World Importers is Why would you use this

What is Wide. World Importers a New sample Database that was developed for MS

Why Adventure. Works was outdated A Replacement or re-Develop of Adventure. Works was needed

Prerequisits Git. Hub Account & Shell Microsoft SQL Server 2016 (Preferably Developers Edition) Visual

How to Clone Get Github Desktop/Shell (Dealers Choice) Clone GIT Repo from shell git

How to Build Wide. World Importers ~wwi-database-scripts Build DB Create metadata Build DB from

How to Build the Data Warehouse ~wwi-dw-database-scripts Build DB Create metadata Build DB from

Load Data Warehouse ~wwi-integration-etl Build SSIS package Deploy to SSIS Catalog Schedule Task

Run Workloads Insert Vehicle Location Data ~workload-driversvehicle-location-insert Insert Orders ~workload-driversorder-insert

Sample Scripts ~sample-scripts Always Encrypted In-Memory OLTP Operational Analytics Polybase Row Level Security

Links GIT Repo : https: //github. com/Microsoft/sql-serversamples/tree/master/samples/databases/wide-world-importers Demo DB History : https: //blogs. msdn.

Slides: 18

Download presentation

Welcome to Wide. World Importers JP Voogt @Cloudy. SQL

Objective We will cover what Wide. World Importers is Why would you use this What do you require to setup Wide. World Importers How to setup Wide. World Importers OLAP Create the Wide. World Importers Warehouse and load it Run a load simulation Sample Scripts

What is Wide. World Importers a New sample Database that was developed for MS SQL 2016 featured

Why Adventure. Works was outdated A Replacement or re-Develop of Adventure. Works was needed to support and test the new features in MS SQL 2016 Books online code samples

Prerequisits Git. Hub Account & Shell Microsoft SQL Server 2016 (Preferably Developers Edition) Visual Studio with Data Tools Patience

How to Clone Get Github Desktop/Shell (Dealers Choice) Clone GIT Repo from shell git clone https: //github. com/Microsoft/sql-serversamples/tree/master/samples/databases/wide-world-importers

How to Build Wide. World Importers ~wwi-database-scripts Build DB Create metadata Build DB from metadata Configure DB objects Load data Enable Full Features (Optional) Create Backup (Optional)

Demo

How to Build the Data Warehouse ~wwi-dw-database-scripts Build DB Create metadata Build DB from metadata Configure DB objects Enable Full Features (Optional) Create Backup (Optional)

Demo

Load Data Warehouse ~wwi-integration-etl Build SSIS package Deploy to SSIS Catalog Schedule Task

Demo

Run Workloads Insert Vehicle Location Data ~workload-driversvehicle-location-insert Insert Orders ~workload-driversorder-insert

Demo

Sample Scripts ~sample-scripts Always Encrypted In-Memory OLTP Operational Analytics Polybase Row Level Security

Demo

Questions

Links GIT Repo : https: //github. com/Microsoft/sql-serversamples/tree/master/samples/databases/wide-world-importers Demo DB History : https: //blogs. msdn. microsoft. com/writingdata_services/2013/09/09/revisite d-the-story-of-pubs-northwind-adventureworks/ Blog : http: //www. sqlshack. com/new-sql-server-2016 -sample-database/