My Interview Published on Technet Wiki

Glad to share with you all the news that my Technet Wiki had interviewed me and they’ve posted the interview on their official blogs. The link is given below http://blogs.technet.com/b/wikininjas/archive/2016/02/22/interview-with-a-wiki-ninja-visakh16-a-sql-server-mvp-microsoft-partner-amp-mcc.aspx Really feeling nice getting this motivation from Microsoft and being…

Identification and Application of Retrospective Changes Done in Databases

Introduction One of the common scenarios that we have come across during the course of every project life cycle is the need to identify the changes done retrospectively and revert them. This usually happens during subsequent phases of the project…

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…