Data Exposed is all about data; relational and non-relational, on-premises and in the cloud, big and small. Get the inside scoop and join us as we demonstrate features, discuss the latest news and share our love for data technology including SQL Server, Azure Data Services like SQL DB, Cosmos DB, SQL DW, Data Factory, Databricks and more!
The best episodes ranked using user listens.
Optimize Existing Databases and Applications with Operational Analytics in Azure SQL - Part 2
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 1 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)
25 Feb 2021