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

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:

 

Resources:
Get started with Columnstore for real-time operational analytics
Sample performance with Operational Analytics in WideWorldImporters
T-SQL Window Functions: For data analysis and beyond, 2nd Edition
Real-Time Operational Analytics: