Azure SQL Data Warehouse Demo

SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. Use SQL Data Warehouse as a key component of a big data solution. Import big data into SQL Data Warehouse with simple PolyBase T-SQL queries, and then use the power of MPP to run high-performance analytics. As you integrate and analyze, the data warehouse will become the single version of truth your business can count on for insights.

Quick Demo

Some Azure SQL DW useful commands:

CREATE MASTER KEY;
CREATE SCHEMA EDW;
CREATE TABLE EDW.VENDOR (SK_VENDOR INT, VENDOR_ID INT, TIP_AMOUNT VARCHAR);
DROP TABLE EDW.VENDOR;
INSERT INTO EDW.VENDOR (SK_VENDOR, VENDOR_ID, TIP_AMOUNT) VALUES (2, 3,2);
SELECT * FROM EDW.VENDOR

Some Power Shell Azure SQL DW useful commands to suspend and resume compute:

Get-Module -ListAvailable AzureRM
Connect-AzureRmAccount
Get-AzureRmSubscription
Set-AzureRmContext -SubscriptionName "RD"
Suspend-AzureRmSqlDatabase –ResourceGroupName "edw-rg" `
–ServerName "edw-sqlserver" –DatabaseName "testsqldw"
Resume-AzureRmSqlDatabase –ResourceGroupName "edw-rg" `
–ServerName "edw-sqlserver" -DatabaseName "testsqldw"

Suspend Azure SQL DW (option to reduce cost)

Resume Azure SQL DW

Power BI connected to Azure SQL Data Warehouse