Posted on:
June 2nd, 2025
Tips and Tricks #123: Partition Large Tables for Query Performance
Use table partitioning to dramatically speed up queries on large datasets.
Tag: Performance
All
All
General
Microsoft
Emerging Technologies
Tips and Tricks
KnowledgeBase
Community
OpenSource
HotFixes
Software/System Design
Posted on:
June 1st, 2025
Azure Traffic Manager: A Solutions Architect’s Guide to Global DNS-Based Load Balancing
In the world of globally distributed applications, ensuring users connect […]
Posted on:
May 31st, 2025
Tips and Tricks #122: Implement Idempotent ETL with Merge Statements
Use MERGE (upsert) for safe, rerunnable data pipelines that handle duplicates gracefully.
Posted on:
May 29th, 2025
Tips and Tricks #121: Use Window Functions for Running Calculations
Calculate running totals, rankings, and moving averages efficiently with SQL window functions.
Posted on:
May 27th, 2025
Tips and Tricks #120: Apply Strangler Fig Pattern for Legacy Migration
Gradually replace legacy systems by routing traffic to new implementations incrementally.
Posted on:
May 19th, 2025
Tips and Tricks #116: Implement Structured Logging for Observability
Use structured JSON logging for better searchability and analysis in cloud environments.