This article is contributed. See the original author and article here.

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.


 


Watch on Data Exposed


 


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)

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.