8 min read
Real-Time Dashboards in Git: Reviewable Changes and a Way Back
Put Fabric Real-Time Dashboards under Git so tile and query changes are reviewed, validated before Update from Git, and reverted cleanly when they break.
KQL
30 articles
9 min read
Fabric Pipeline Deadlines: Alert on a Late Run Before Anyone Asks
How to catch a slipping Fabric pipeline before its deadline: alert on missing and late runs, not just failures, using job events, KQL and the jobs API.
9 min read
Pricing a Threshold: Tying Fabric Activator Rules to Business Impact
Set Fabric Activator and KQL alert thresholds from the cost of a miss versus the cost of acting, then tier actions by the value at risk, not the raw reading.
9 min read
Store Changes, Not Readings: Shaping Noisy Streams in an Eventhouse
Use update policies, materialized views and a KQL state-change function in a Fabric Eventhouse to strip duplicates, chatter and flapping before anyone queries.
8 min read
Fabric Pipeline Latency: Find Where the Minutes Actually Go
How to split a slow Fabric pipeline run into start delay, queueing, Spark start-up, copy transfer and idle gaps, with KQL and the activity runs API.
7 min read
Noise or a Real Change? Three KQL Checks Before Anyone Gets Paged
Use KQL baselines, week-over-week comparison and diffpatterns in an Eventhouse to tell a meaningful operational change from ordinary noise, and to explain it.
8 min read
Alerts People Don't Mute: Designing Activator Rules in Fabric
How to design Fabric Activator and KQL queryset alerts that fire on transitions, carry an owner and a next step, and stop teams muting the channel.
8 min read
Why Real-Time Dashboards Rot After Week One, and How to Stop It
Rules for Fabric Real-Time Dashboards that stay trusted: tiles with owners, visible data freshness, refresh costs you can afford, and thresholds in tables.
8 min read
Equipment Monitoring on Fabric Real-Time Intelligence, End to End
One sensor-monitoring design on Fabric Real-Time Intelligence: where to filter, enrich, aggregate and alert, and what Eventhouse retention costs you.
8 min read
KQL for SQL People: The Query Language Azure Already Runs On
Why KQL is a baseline Azure skill, how its pipe model differs from SQL, and the operators, join defaults and has-vs-contains traps that matter most.
1 min read
Microsoft Fabric Real-Time Analytics: Streaming Data Pipelines
Eventhouse is the storage layer optimized for time-series and streaming data. It automatically indexes data for lightning-fast queries.
1 min read
Microsoft Fabric Real-Time Intelligence: Streaming Analytics at Scale
Microsoft Fabric's Real-Time Intelligence workload has matured significantly since GA. Today I'm exploring how to build streaming analytics pipelines that…
3 min read
Microsoft Fabric Real-Time Intelligence: Patterns for Streaming Analytics
Microsoft Fabric's Real-Time Intelligence workload has matured significantly since GA. We've implemented several production streaming scenarios, and I want…
7 min read
Where Streaming Logic Belongs in Fabric: Eventstream, KQL or Spark
A decision guide for placing filters, enrichment, aggregation and alerts across Eventstream, Eventhouse and Spark in Fabric Real-Time Intelligence.
1 min read
KQL Querysets in Microsoft Fabric
KQL Querysets are the analysis layer of Real-Time Intelligence in Fabric. Today I'm exploring how to write effective KQL for real-time analytics.
1 min read
Eventhouses in Microsoft Fabric: Deep Dive
Eventhouses are the foundation of Real-Time Intelligence in Fabric. Today I'm exploring their architecture and capabilities in depth.
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.
8 min read
Fabric Eventstream Patterns: Deciding Where Stream Logic Lives
Practical Fabric Eventstream patterns: what belongs in the no-code event processor, what belongs in KQL, and what to fix before events arrive.
6 min read
Fabric Real-Time Analytics After GA: An End-to-End Streaming Design
How Eventstream, KQL databases, Power BI and the Data Activator preview fit together in Fabric as of January 2024, and when to choose something else.
1 min read
KQL Databases: Advanced Patterns and Techniques
'{ "SoftDeletePeriod": "90.00:00:00", "Recoverability": "Enabled" }' '{ "DataHotSpan": "7.00:00:00", "IndexHotSpan": "14.00:00:00" }'
1 min read
Fabric Real-Time Analytics: Stream Processing at Scale
'{' ' "SoftDeletePeriod": "30.00:00:00",' ' "Recoverability": "Enabled"' '}'
1 min read
Synapse Real-Time Analytics in Microsoft Fabric: Streaming at Scale
Real-Time Analytics in Fabric provides powerful streaming capabilities for time-sensitive workloads. Tomorrow, I will cover Power BI integration in Fabric.
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
Cross-Workspace Queries in Azure Monitor
Cross-workspace queries in KQL let you write a single query that spans multiple Log Analytics workspaces—essential when your monitoring architecture splits…
1 min read
Azure Resource Graph for Cross-Subscription Queries
Azure Resource Graph is the query service that answers "what do we actually have in Azure?" at enterprise scale in milliseconds. The ARM APIs query each…
1 min read
Mastering Log Analytics Queries with KQL
KQL is the query language I've spent the most hours in this year that most developers have never heard of. If you use Log Analytics, Sentinel, Application…
7 min read
Azure Monitor Workbooks as an Incident Triage Tool, Not a Wallboard
Design an Azure Monitor workbook for incident triage on workspace-based Application Insights, with sampling-safe KQL, drill-down and ARM deployment.
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.
1 min read
Azure Resource Graph: Query All Your Azure Resources
Resource Graph is essential for understanding your Azure estate at scale.
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.