How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1 | Data Exposed

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 upResources: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)

Om Podcasten

Channel 9 is a community. We bring forward the people behind our products and connect them with those who use them. We think there is a great future in software and we're excited about it. We want the community to participate in the ongoing conversation. This is the heart of Channel 9. We talk about our work but listen to the customer.