DiscoverChannel 9Optimize Existing Databases and Applications with Operational Analytics in Azure SQL - Part 2 | Data Exposed
Optimize Existing Databases and Applications with Operational Analytics in Azure SQL - Part 2  | Data Exposed

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

Update: 2021-02-25
Share

Description

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:
 
Comments 
In Channel
loading
Download from Google Play
Download from App Store
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

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

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

Anna Hoffman, Marisa Brasile