filmov
tv
Optimize Existing Databases & Apps with Operational Analytics in Azure SQL - Part 2 | Data Exposed
Показать описание
You don’t necessarily need to change your data models and applications to run operational analytics workloads on Azure SQL. In part two of this three-part series with Silvano Coriani, we will explore Azure SQL capabilities to optimize your databases for mixed workloads on real-time data.
0:00 Introduction
1:47 Traditional Analytical Architecture
3:10 Minimizing Data Latency for Analytics
4:42 Operational Analytics: Nonclustered Columnstore Index (NCCI)
6:19 Demo: Operational Analytics with Nonclustered Columstore Index
10:35 Operational Analytics: Columnstore on In-Memory Tables
14:45 Demo
18:45 Getting started
🎞️ More episodes in this Operational Analytics Series:
✔️ 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:
📌 Let's connect:
🔔 Subscribe to our channels for even more SQL tips:
#OperationalAnalytics #HTAP #AzureSQL
0:00 Introduction
1:47 Traditional Analytical Architecture
3:10 Minimizing Data Latency for Analytics
4:42 Operational Analytics: Nonclustered Columnstore Index (NCCI)
6:19 Demo: Operational Analytics with Nonclustered Columstore Index
10:35 Operational Analytics: Columnstore on In-Memory Tables
14:45 Demo
18:45 Getting started
🎞️ More episodes in this Operational Analytics Series:
✔️ 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:
📌 Let's connect:
🔔 Subscribe to our channels for even more SQL tips:
#OperationalAnalytics #HTAP #AzureSQL
0:20:53
Optimize Existing Databases & Apps with Operational Analytics in Azure SQL - Part 2 | Data Expo...
0:03:18
SQL Query Optimization - Tips for More Efficient Queries
0:05:57
Secret To Optimizing SQL Queries - Understand The SQL Execution Order
0:51:20
Optimizing Your Data for Better Performance
0:31:40
PowerApps Performance Optimization - Use Monitor to understand Patch of data sources
0:06:48
How To Optimize Your WordPress Database
0:05:22
Database vs Data Warehouse vs Data Lake | What is the Difference?
0:04:02
How to optimize a Stored Procedure or SQL Query ?
0:56:25
Dive into Chunking Strategies for RAG with Zain 💚
0:05:33
How to optimize your Cloud Spanner Schema
0:02:44
How to optimize photo, video and app data storage
0:42:44
Optimize data usage when using Microsoft Graph with query parameters
0:38:45
Optimizing Performance of Stateful Apps for Globally Distributed Users • Ben Darnell • GOTO 2018
0:16:55
Improving App Performance: Virtual Column Optimization
0:04:43
Unlock the Power of Data-Driven Decision Making with Decision Optimization
0:50:03
Andy Pavlo - OtterTune: Using Machine Learning to Automatically Optimize Database Configurations
0:11:13
How To Optimize Your Google Ads Campaign In 2024 (Full Guide With Real Results)
0:21:36
Power Apps Performance Optimization Tips
0:33:34
Optimize your app size with this one trick (Android Dev Summit '18)
0:05:26
Back to Basics: Using AWS Config and Conformance Packs to Optimize Your Database
0:07:29
SQL Query Optimization and performance tuning | SQL Tutorial for Beginners in Hindi
0:49:25
Optimizing Applications, Schemas, and Query Design on Cloud Spanner (Cloud Next '18)
0:34:53
Optimize read from Relational Databases using Spark
0:17:02
React Native Performance Optimisation (useMemo, useCallback, memo)
Комментарии