1 min read
Azure Arc-Enabled PostgreSQL Hyperscale
Azure Arc-enabled PostgreSQL Hyperscale brings the best of Azure's managed database services to wherever your data needs to live.
Blog
Thoughts on data engineering, cloud architecture, and technology. 2205 articles and counting.
Showing 24 of 2205 posts — page 62 of 92
1 min read
Azure Database for PostgreSQL Flexible Server Deep Dive
Flexible Server gives you the power of managed PostgreSQL with the flexibility to tune it for your specific needs.
2 min read
Scaling Reads with MySQL Read Replicas on Azure
Read replicas in Azure Database for MySQL Flexible Server enable scaling out read-heavy workloads by directing reporting queries, analytical queries, and…
1 min read
High Availability Architecture for MySQL on Azure
Implementing these HA patterns ensures your MySQL applications remain resilient during infrastructure failures.
1 min read
Leveraging MySQL 8.0 Features on Azure
MySQL 8.0 features significantly enhance your application capabilities on Azure Database for MySQL Flexible Server.
1 min read
Azure Database for MySQL Flexible Server: A Complete Guide
Flexible Server provides the enterprise features you need while maintaining the simplicity of a managed service.
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
Building Real-Time Dashboards with Citus
Combining Citus's distributed query power with rollup tables and caching enables dashboards that handle millions of events per second.
1 min read
Data Colocation in Citus for Optimal Join Performance
When two distributed tables share the same distribution column and colocation group, their corresponding shards are placed on the same worker node.
1 min read
Mastering Distributed Queries in Citus
Understanding these query patterns helps you leverage Citus effectively for high-performance distributed PostgreSQL applications.
1 min read
Using Reference Tables in Citus for Efficient Joins
Reference tables eliminate network round-trips for joins, significantly improving query performance in distributed setups.
1 min read
Sharding Strategies for Distributed PostgreSQL
The distribution column (also called the shard key) determines how data is partitioned across nodes. Citus uses consistent hashing on this column to assign…
1 min read
Understanding Hyperscale Citus Architecture
Understanding this architecture helps you make informed decisions about data modeling and query optimization in your distributed PostgreSQL deployments.
1 min read
Getting Started with Azure Cosmos DB for PostgreSQL
Azure Cosmos DB for PostgreSQL is a managed database service that extends PostgreSQL with distributed capabilities. It uses the Citus extension to transform…
3 min read
Azure Databricks Unity Catalog: Unified Data Governance for the Lakehouse
Unity Catalog provides a unified governance layer across all your Databricks workspaces. Metastore: The top-level container for all metadata. You create one…
1 min read
Pattern Matching in Streaming Data: Detecting Complex Events
Pattern matching in streaming data enables: Sequence detection Anomaly identification Business rule enforcement Fraud detection Predictive maintenance Azure…
1 min read
Temporal Joins: Correlating Events Across Time
Temporal joins and windows enable sophisticated event correlation, essential for IoT analytics, fraud detection, and user behavior analysis.
1 min read
Reference Data Joins in Stream Analytics
Static : Loaded once at job start Periodic : Refreshes at intervals Dynamic : SQL queries for latest data Reference data joins combine streaming data with…
1 min read
Azure Stream Analytics Updates: No-Code Editor and More
The new visual editor allows building streaming pipelines without SQL: 1. Drag and drop input/output connections 2. Visual transformations and aggregations…
1 min read
Real-Time Analytics on Azure: Building Live Dashboards
Azure's real time analytics stack enables instant insights from millions of events per second, powering live dashboards and alerts.
1 min read
Azure Web PubSub: Native WebSocket at Scale
Azure Web PubSub offers native WebSocket support with powerful server side messaging APIs, ideal for IoT, gaming, and collaboration apps.
1 min read
SignalR Scaling: Building Scalable Real-Time Applications
Azure SignalR Service scales real time applications effortlessly, handling millions of connections with automatic load balancing.
1 min read
Long Polling: Real-Time Patterns for Legacy Systems
Long polling is the workaround for near-real-time notifications in environments where WebSocket connections aren't available—the client sends an HTTP…
1 min read
Server-Sent Events: Simple Real-Time Updates
Feature SSE WebSocket Direction Server to client Bidirectional Protocol HTTP WebSocket Reconnection Automatic Manual Binary data No Yes SSE offers a simple,…