Episode

Optimize Existing Databases and Applications with Operational Analytics in Azure SQL - Part 2

Data Exposed

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.
 
[01:47] Traditional Analytical Architecture
[03:10] Minimizing Data Latency for Analytics
[04:42] Operational Analytics: Nonclustered Columnstore Index (NCCI)
[06: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: