Protect Your SQL Anywhere Using Azure Defender for SQL

Build with an Azure free account. Get USD200 credit for 30 days and 12 months of free services.
Start free todayAzure 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
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)