Running complex aggregations and analytical functions on real-time operational databases is a powerful capability in Azure SQL. In the last part of this three-part series with Silvano Coriani, we will see how Window Functions can be a great tool to express analytical calculations on real-time data sets.
More episodes in this Operational Analytics Series:
How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1
How to Optimize Existing Databases & Applications with Operational Analytics in Azure SQL - Part 2
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)
Updated Mar 05, 2021
Version 1.0MarisaMathews
Microsoft
Joined May 14, 2020
Azure SQL Blog
Follow this blog board to get notified when there's new activity