Posted on:
August 5th, 2025
Tips and Tricks #155: Partition Large Tables for Query Performance
Use table partitioning to dramatically speed up queries on large datasets.
Year: 2025
All
All
General
Microsoft
Emerging Technologies
Tips and Tricks
KnowledgeBase
Community
OpenSource
HotFixes
Software/System Design
Posted on:
August 3rd, 2025
The Architecture Decision That Will Make or Break Your System: Monolith vs Microservices in 2025
The debate between monolithic and microservices architectures has evolved significantly […]
Posted on:
August 3rd, 2025
Tips and Tricks #154: Implement Idempotent ETL with Merge Statements
Use MERGE (upsert) for safe, rerunnable data pipelines that handle duplicates gracefully.
Posted on:
August 1st, 2025
Tips and Tricks #153: Use Window Functions for Running Calculations
Calculate running totals, rankings, and moving averages efficiently with SQL window functions.
Posted on:
July 30th, 2025
Tips and Tricks #152: Apply Strangler Fig Pattern for Legacy Migration
Gradually replace legacy systems by routing traffic to new implementations incrementally.
Posted on:
July 28th, 2025
Tips and Tricks #151: Implement Domain Events for Loose Coupling
Use domain events to decouple components and enable reactive architectures.