Tag: Data Engineering

All All General Microsoft Emerging Technologies Tips and Tricks KnowledgeBase Community OpenSource HotFixes Software/System Design

November 20th, 2024

Tips and Tricks #26: Implement Idempotent ETL with Merge Statements

Use MERGE (upsert) for safe, rerunnable data pipelines that handle duplicates gracefully.

Nithin Mohan TK

November 18th, 2024

Tips and Tricks #25: Use Window Functions for Running Calculations

Calculate running totals, rankings, and moving averages efficiently with SQL window functions.

Nithin Mohan TK

Previous
1
…
5
6
7

Searching in

Enter search term to find items

to navigate, to select, and to close