The Modern Data Warehouse

Overview

Explore the evolution of data warehousing in this 57-minute conference talk from PASS Data Community Summit. Learn about Microsoft's approach to adapting existing data warehouse infrastructure to handle the explosive growth in data volume, variety, and velocity. Discover how to scale out relational data to petabytes using Parallel Data Warehouse technologies, and non-relational data with HDInsight. Understand the benefits of in-memory columnstore for enhanced performance and how to manage mixed workloads effectively. Delve into big data concepts, including Hadoop and its various offerings for on-premise and cloud deployments. Examine the integration of relational data and Hadoop using PolyBase, and explore the flexibility of deployment options and hybrid solutions in modern data warehousing.

Syllabus

Intro
SQL Server 2014 Webinar Series
The traditional data warehouse
The modern data warehouse
Microsoft's modern data warehouse
Scale out relational data to petabytes Scale out technologies in the Parallel Data Warehouse
Scale out non-relational data Scale out non-relational data in HDinsight (for Azure or PDW)
In-memory performance In-memory columnstore for next-generation performance
Concurrency and mixed workloads Great performance for mixed workloads
What is big data?
What is Hadoop?
Hadoop Offerings On-Premise and Cloud Hadoop cluster in HDP for Windows, Appliance and Cloud
Integrate relational data and Hadoop Integrated query With PolyBase in the Parallel Data Warehouse
Freedom of deployment options and hybrid solutions