Skip to content

Data Engineering with Salim Saeedi

AWS and Azure Musings

  • About

SQL

Using MERGE for SCD Type 2 with multiple updates

December 24, 2020 by admin

Below is the typical MERGE statement for SCD Type 2: Since a MERGE statement cannot update more than one match at a time, in scenarios which the source contains historical data that for each matching key (per ON statament) may need more than 1 action in a single merge statement run (e.g. one INSERT and … Read more

Categories Tutorial Tags MERGE, scd, slowly changing dimension, SQL Leave a comment

Prevent Concurrent runs for a SQL Stored Procedure

January 7, 2020 by admin

Suppose you have a SQL Stored Procedure and need to prvenet users or processes to run it concurrently.

Categories Tutorial Tags Concurrency, Lock, SQL, Stored Procedure Leave a comment

Shrink SQL Database

January 7, 2020January 7, 2020 by admin

How to shrink a SQL Database and manage log file size?

Categories Tutorial Tags log, shrink, SQL Leave a comment

Recent Posts

  • Databricks not recognizing updated Service Principal Secret
  • Inline Try-Catch for Azure Data Factory activity output
  • Using MERGE for SCD Type 2 with multiple updates
  • Dynamic 365 Audit History Export through Power BI
  • Pipenv dependency resolution procedure

Recent Comments

    Archives

    • August 2022
    • March 2021
    • December 2020
    • May 2020
    • January 2020

    Categories

    • Tutorial
    © 2023 Data Engineering with Salim Saeedi • Built with GeneratePress