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

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

Update: 2021-02-18
Share

Description

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.

[00:49 ]​ Different type of workloads
[03:59 ]​ Hybrid transaction/analytical processing
[04:45 ]​ Enable HTAP: real-time operational analytics
[07:00 ]​ Coming up

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:
Memory-Optimized Tables and Columnstore Index
DML operations and nonclustered columnstore index (NCCI) in SQL Server 2016
Filtered nonclustered columnstore index (NCCI)

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

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

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

Anna Hoffman, Marisa Brasile