SSIS Tips: Performing Cross Join Using Merge Join Transform in SSIS

Question Can we perform cross join (cartesian product) operation using Merge Join transform in SSIS? Scenario The above question was asked in one of the social forums recently. I was able to give the response to this.I’m sharing the solution…

T-SQL Tips: Execute Individual Packages in Project Deployment Model using Dtexec

Question Can we execute individual packages included in a SSIS 2012 project configured in project deployment model using dtexec utility? Scenario The above question was the main topic of discussion in one of the recent casual conversations with my fellow…

In Memory Tables vs Table Variables – Comparison

IntroductionRecently there was a casual discussion with one of my colleagues who was asking me regarding the newly introduced memory-optimized tables in SQL Server 2014. The discussion went through few aspects of memory-optimized tables and their comparison against table variables. This blog…