Optimize Existing Databases & Apps with Operational Analytics in Azure SQL - Part 2 | Data Exposed

From the creator

You don’t necessarily need to change your data models and applications to run operational analytics workloads on Azure SQL. In part two of this three-part series with Silvano Coriani, we will explore Azure SQL capabilities to optimize your databases for mixed workloads on real-time data. 0:00 Introduction 1:47 Traditional Analytical Architecture 3:10 Minimizing Data Latency for Analytics 4:42 Operational Analytics: Nonclustered Columnstore Index (NCCI) 6:19 Demo: Operational Analytics with Nonclustered Columstore Index 10:35 Operational Analytics: Columnstore on In-Memory Tables 14:45 Demo 18:45 Getting started 🎞️ 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/databas

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