How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1 | Data Exposed

From the creator

Azure SQL enables hybrid transactional/analytical workloads for real-time operational analytics scenarios through a mix of in-memory and columnar database technologies. In the first episode of this three-part series with Silvano Coriani, we will explore Azure SQL capabilities to run a mix of transactional and analytical queries on the same underlying data store. 0:00 Introduction 0:49 Different type of workloads 3:59 Hybrid transaction/analytical processing 4:45 Enable HTAP: real-time operational analytics 7:00 Coming up 🎞️ More episodes in this Operational Analytics Series: How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1: https://youtu.be/L0pnYWctrY4?WT.mc_id=dataexposed-c9-niner How to Optimize Existing Databases & Applications with Operational Analytics in Azure SQL - Part 2: https://youtu.be/dKhsHVqG8XU?WT.mc_id=dataexposed-c9-niner How to Create Operational Analytics with Window Functions in Azure SQL - Part 3: https://youtu.be/h0Ik8VWxI4Q?WT.mc_id=dataexposed-c9-niner ✔️ Resources: Get started with Columnstore for real-time operational analytics: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/get-started-with-columnstore-for-real-time-operational-analytics?WT.mc_id=dataexposed-c9-niner Sample performance with Operational Analytics in WideWorldImporters: https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/wide-world-importers/sample-scripts/operational-analytics?WT.mc_id=dataexposed-c9-niner T

Published 2021-02-18 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.