Episode

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

More episodes in this Operational Analytics Series:
How to Optimize Existing Databases & Applications with Operational Analytics in Azure SQL - Part 2
How to Create Operational Analytics with Window Functions in Azure SQL - Part 3

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)