Optimize Existing Databases & Apps with Operational Analytics in Azure SQL - Part 2 | Data Exposed
Published Feb 25 2021 10:43 AM 1,120 Views

You don’t necessarily need to change your data models and applications to run operational analytics workloads on Azure SQL. In part two of this three-part series with Silvano Coriani, we will explore Azure SQL capabilities to optimize your databases for mixed workloads on real-time data.


Watch on Data Exposed


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)


View/share our latest episodes on Channel 9 and YouTube!

Version history
Last update:
‎Feb 25 2021 10:43 AM
Updated by: