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

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.

0:00 Introduction
1:30 Operational Analytics: what kind of analytics?
3:12 A Common Business Scenario
5:10 Old school
6:22 Performance with self-join and subqueries
6:42 New school
8:01 Performance with Window Functions
8:50 Demo: Performance with Window Functions
13:18 Window Functions capabilities
14:54 Getting started

🎞️ More episodes in this Operational Analytics Series:

✔️ 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:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#OperationalAnalytics​ #HTAP​ #AzureSQL

[agogelabs]

Is a Windows Funcation the same as an Azure Function? Could you use them in Azure Functions?