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
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.
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,