Tag "merge"

Script and deploy the data for database from SSDT project

This post is a part of the series about SSDT and database project leveraging Visual Studio. We already know that SSDT can cover all objects but only on a database

Podcast 1 Comment

ASF 026: Aaron Bertrand interview

Introduction Aaron Bertrand is a Product Manager at SentryOne, with industry experience dating back to Classic ASP and SQL Server 6.5. In his spare time, he is either playing volleyball,

Last Week Reading (2019-07-28)

I believe that most of you have got a holiday already (enjoy!) or are planning some now. This is the last post of “Last Week Reading” series before my holiday.

Data Warehousing 14 Comments

SCD type 1 & type 2 in MERGE statement

In my previous article, I have explained what does the SCD and described the most popular types of Slowly Changing Dimensions. I also mentioned that for one process, one table,