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 todayHow Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1
Play How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1
Description
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
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)
Download
rss
The Discussion
More episodes in this series
How to Deploy Azure SQL Anywhere – Using Azure Arc for Data Services
Related episodes
Optimize Existing Databases and Applications with Operational Analytics in Azure SQL -…
How to Deploy Azure SQL Anywhere – Using Azure Arc for Data Services
Protect Your SQL Anywhere Using Azure Defender for SQL
Testing App Cloud Readiness for Failover Resiliency with SQL Managed Instance
A Tour of SQL Workshops
Azure SQL Connectivity Performance Tips & Tricks
Simplify Authentication with Managed Identities for Azure Resources
How to Troubleshoot Elastic Jobs in Azure SQL Database
Running & Monitoring Elastic Jobs in Azure SQL Database Using PowerShell and T-SQL
How to Create Elastic Jobs in Azure SQL Database Using T-SQL
