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" }'
Time Series
8 articles
1 min read
Database Patterns for IoT Applications
These patterns form the foundation for building scalable, performant IoT database solutions.
1 min read
Time-Series Data at Scale with Citus and TimescaleDB
This architecture handles billions of time-series data points while maintaining query performance for both real-time and historical analysis.
1 min read
InfluxDB on Azure: Deploying Time-Series Infrastructure
For development or small workloads: For production workloads, use AKS with persistent volumes:
2 min read
TimescaleDB on Azure: Time-Series Data at Scale
TimescaleDB is the time-series database I recommend to teams that are already comfortable with PostgreSQL and don't want to learn a new query language or…
1 min read
Time Series Anomaly Detection with Azure Anomaly Detector
Anomaly Detector is the Cognitive Service I pull out when someone asks "can you tell us when something goes wrong?" and the answer is "I don't know exactly…
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 Time Series Insights: IoT Analytics at Scale
A general-purpose database can store time-stamped data. It just gets sad about it once you're past a few hundred million rows and someone wants a five-year…