How to Create Operational Analytics with Window Functions in Azure SQL - Part 3 | Data Exposed
Published Mar 05 2021 09:00 AM 1,610 Views
Microsoft

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)

Co-Authors
Version history
Last update:
‎Mar 05 2021 07:27 AM
Updated by: