Posted on:
December 11th, 2025
Tips and Tricks #219: Partition Large Tables for Query Performance
Use table partitioning to dramatically speed up queries on large datasets.
Month: December 2025
All
All
General
Microsoft
Emerging Technologies
Tips and Tricks
KnowledgeBase
Community
OpenSource
HotFixes
Software/System Design
Posted on:
December 9th, 2025
Tips and Tricks #218: Implement Idempotent ETL with Merge Statements
Use MERGE (upsert) for safe, rerunnable data pipelines that handle duplicates gracefully.
Posted on:
December 7th, 2025
Orchestrating Chaos: Why AWS Step Functions Became My Secret Weapon for Building Resilient Distributed Systems
Three years ago, I inherited a distributed system that processed […]
Posted on:
December 7th, 2025
Tips and Tricks #217: Use Window Functions for Running Calculations
Calculate running totals, rankings, and moving averages efficiently with SQL window functions.
Posted on:
December 5th, 2025
Tips and Tricks #216: Apply Strangler Fig Pattern for Legacy Migration
Gradually replace legacy systems by routing traffic to new implementations incrementally.
Posted on:
December 3rd, 2025
Tips and Tricks #215: Implement Domain Events for Loose Coupling
Use domain events to decouple components and enable reactive architectures.