Blog Post

Azure SQL Blog
1 MIN READ

How to Create Operational Analytics with Window Functions in Azure SQL - Part 3 | Data Exposed

MarisaMathews's avatar
MarisaMathews
Icon for Microsoft rankMicrosoft
Mar 05, 2021

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)

Updated Mar 05, 2021
Version 1.0
No CommentsBe the first to comment