1 min read
KQL for Real-Time Analytics: Patterns and Performance
KQL is deceptively simple; over the years I've used it to squeeze sub-second insights from streaming data. Below are the query patterns and optimizations…
Azure Data Explorer
7 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…
1 min read
Azure Data Explorer: Fast Analytics on Log Data
For log analytics at scale, ADX is hard to beat.