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

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

 

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)

 

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

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