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

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

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)

Read more here:

Content Attribution

This content was originally published by Anna Hoffman, Marisa Brasile at Channel 9, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: