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. [01:47] Traditional Analytical Architecture[03:10] Minimizing Data Latency for Analytics[04:42] Operational Analytics: Nonclustered Columnstore Index (NCCI)[06:19] Demo: Operational Analytics with Nonclustered Columstore Index[10:35] Operational Analytics: Columnstore on In-Memory Tables[14:45] Demo[18:45] Getting startedMore episodes in this Operational Analytics Series:How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1How to Create Operational Analytics with Window Functions in Azure SQL - Part 3 Resources:Get started with Columnstore for real-time operational analyticsSample performance with Operational Analytics in WideWorldImportersT-SQL Window Functions: For data analysis and beyond, 2nd EditionReal-Time Operational Analytics:Memory-Optimized Tables and Columnstore IndexDML operations and nonclustered columnstore index (NCCI) in SQL Server 2016Filtered nonclustered columnstore index (NCCI)