Sign up to save your podcasts
Or
Share How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1
Azure SQL enables hybrid transactional/analytical workloads for real-time operational analytics scenarios through a mix of in-memory and columnar database technologies. In the first episode of this three-part series with Silvano Coriani, we will explore Azure SQL capabilities to run a mix of transactional and analytical queries on the same underlying data store. [00:49] Different type of workloads[03:59] Hybrid transaction/analytical processing[04:45] Enable HTAP: real-time operational analytics[07:00] Coming up More episodes in this Operational Analytics Series:How to Optimize Existing Databases & Applications with Operational Analytics in Azure SQL - Part 2How to Create Operational Analytics with Window Functions in Azure SQL - Part 3Resources: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)
View all episodes
By MicrosoftAzure SQL enables hybrid transactional/analytical workloads for real-time operational analytics scenarios through a mix of in-memory and columnar database technologies. In the first episode of this three-part series with Silvano Coriani, we will explore Azure SQL capabilities to run a mix of transactional and analytical queries on the same underlying data store. [00:49] Different type of workloads[03:59] Hybrid transaction/analytical processing[04:45] Enable HTAP: real-time operational analytics[07:00] Coming up More episodes in this Operational Analytics Series:How to Optimize Existing Databases & Applications with Operational Analytics in Azure SQL - Part 2How to Create Operational Analytics with Window Functions in Azure SQL - Part 3Resources: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)