SQL Server Features & Components, Workshops

SQF01 Workshop: Azure SQL Data Warehouse: A Full Day of the Transformative New NDA Features

11/22/2019

8:00am - 5:00pm

Level: Intermediate

Bradley Ball

Sr. Azure Engineer, Azure FastTrack CXP

Microsoft

Josh Luedeman

SR FastTrack Engineer, Azure Engineering, CXP

Microsoft

Gareth Swanepoel

Sr Program Manager

Microsoft

Join members of the Microsoft Azure SQL DW & Azure FastTrack Engineering PG as we review some amazing new NDA features have been released that drastically change and simplify the recommended best practices and architectural guidance for deploying and using Azure SQL Data Warehouse, aka SQL DW. We will review the concept of multi-node parallel processing, MPP, systems demonstrating concepts to achieve the best performance possible. No longer will you require a data mart or Azure Analysis Services Tabular model for reporting! We will walk through a decision matrix to determine which MPP big data system is right for you based on your needs and workloads. We will review how data science teams can access data utilizing notebooks, R, Python, or Scala. We will review performance benchmarks comparing the performance of SQL DW against Google Big Query, AWS Redshift, and Snowflake.

You will learn:

  • Review a decision-making matrix to determine the right big data solution for you & MPP Concepts for big data systems
  • Review performance benchmarks comparing Google Big Query, AWS Redshift, Snowflake, and SQL DW & how to utilize data science and notebooks with SQL DW
  • Review the new NDA features in Azure SQL DW