7 min read
Keeping KQL Fast on Streaming Data: Query Habits That Matter
The KQL habits that keep queries over streaming telemetry fast in Fabric KQL databases and Azure Data Explorer, and the shortcuts that quietly slow them down.
Azure Data Explorer
8 articles
2 min read
External Tables in Azure Data Explorer
External tables in ADX expose data in Azure Blob Storage or ADLS Gen2 as queryable tables without ingesting the data into ADX—useful when the data is too…
2 min read
Materialized Views in Azure Data Explorer
Materialized views in ADX pre-aggregate data according to a defined query, updating continuously as new data is ingested—so when you query the view, you're…
2 min read
Kusto Functions for Reusable Query Patterns
KQL functions in Azure Data Explorer are the reusability mechanism that prevents the same complex query logic from being copy-pasted across dashboards…
2 min read
ADX Continuous Export for Data Archival and Compliance
ADX Continuous Export is the managed pipeline that continuously moves data from ADX tables to Azure Blob Storage or ADLS Gen2—useful for archiving cold data…
2 min read
Azure Data Explorer Integration for Advanced Analytics
Azure Data Explorer is the analytics service that addresses a specific limitation of Log Analytics: KQL query performance on large historical datasets…
8 min read
Azure Data Explorer for IoT Telemetry: Ingestion, Caching and Rollups
Designing an Azure Data Explorer database for device telemetry: queued vs streaming ingestion, hot cache sizing, materialized views and KQL time series.
8 min read
Azure Data Explorer or Log Analytics? Choosing Where Logs Live
Log Analytics and Azure Data Explorer share the Kusto engine; here is when a dedicated ADX cluster is worth it for log data and when it isn't.