How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1 | Data Exposed скачать в хорошем качестве

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. 0:00 Introduction 0:49 Different type of workloads 3:59 Hybrid transaction/analytical processing 4:45 Enable HTAP: real-time operational analytics 7:00 Coming up 🎞️ More episodes in this Operational Analytics Series: How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1:    • How Azure SQL Enables Real-time Operationa...   How to Optimize Existing Databases & Applications with Operational Analytics in Azure SQL - Part 2:    • Optimize Existing Databases & Apps with Op...   How to Create Operational Analytics with Window Functions in Azure SQL - Part 3:    • How to Create Operational Analytics with W...   ✔️ Resources: Get started with Columnstore for real-time operational analytics: https://docs.microsoft.com/en-us/sql/... Sample performance with Operational Analytics in WideWorldImporters: https://github.com/microsoft/sql-serv... T-SQL Window Functions: For data analysis and beyond, 2nd Edition: https://www.microsoftpressstore.com/s... Real-Time Operational Analytics: Memory-Optimized Tables and Columnstore Index - https://docs.microsoft.com/en-us/arch... DML operations and nonclustered columnstore index (NCCI) in SQL Server 2016 - https://docs.microsoft.com/en-us/arch... Filtered nonclustered columnstore index (NCCI) - https://docs.microsoft.com/en-us/arch... 📌 Let's connect: Twitter: Silvano Coriani,   / scoriani   Twitter: Anna Hoffman,   / analyticanna   Twitter: AzureSQL, https://aka.ms/azuresqltw 🔴 To check out even more Data Exposed episodes, see our playlist: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #OperationalAnalytics #HTAP #AzureSQL