Analytics in SQL Server and Azure SQL Database
summary
Covers concrete features and demos: in-memory OLTP plus clustered/nonclustered columnstore enable mixed transactional/analytical workloads; a simulated IoT demo shows a primary plus in-region synchronous and out-of-region asynchronous readable secondaries (connect via application intent=readonly) with observable replication lag; temporal tables combine memory-optimized write table with a columnstore history for fast analytics. Data virtualization uses the new REST/S3 connector, Parquet/Delta support, CTAS export and external tables with statistics. Synapse Link pushes transaction-log changes into ADLS Gen2 then a dedicated SQL pool (initial snapshot then near-real-time), requires primary keys, consumes concurrency slots and can delay log truncation if the landing zone is unavailable.
AI-written summary · about
chapters (7)
- 0:00Start
- 2:26HTAP/Translytical Features of SQL Server
- 17:14Data Virtualization - Journey
- 19:25Data Virtualization - Design
- 20:17Data Virtualization - Scenarios
- 30:39What is Azure Synapse Link for SQL?
- 32:44How it Works - SQL Server 2022
related talks
55mAzure SQL database, Azure Synapse Analytics, Azure Databricks?
47mImplement a Serverless Data Analytics strategy with Microsoft Azure
53mOptimizing your Azure SQL Database workloads
54mOLAP on the Cloud with Azure Databricks and Azure Synapse
32mSynapse Serverless SQL Pool: SQL without database
28mArchitecture patterns of Azure Cosmos DB
28mArchitecture patterns of Azure Cosmos DB & Azure Synapse Analytics
57mOptimize “All Data” with a Modern Data Warehouse Solution