Introduction In this blog post you will learn how to install SSIS addon SSIS PowerPack (30+ extra tasks/components) and also how to install SSIS client/server tools. There are various versions of SSIS (Microsoft SQL Server Integration Services) such as SSIS 2008, SSIS …

How to install SSIS 2012, 2014, 2016 (SSDT-BI for Visual Studio) Read more »

T SQL Date format convert function

If you ever wonder which one is really faster in Distinct vs Group By Performance Test then I will show some facts in this post so you can write your query accordingly.   To test distinct vs group by performance in SQL Query …

DISTINCT vs GROUP BY Performance in SQL Query Read more »

Yesterday Microsoft Azure services took a big leap forward by announcing their fully managed Cloud based NoSQL Database Service named as “DocumentDB” which will run under Azure Cloud Computing Platform. What is NoSQL database NoSQL database is a different category …

Learn Microsoft DocumentDB – Fully managed NoSQL Database offering for Azure Platform Read more »

I just installed few tools on my new laptop and at some point Visual Studio 2012 started throwing error “Exception has been thrown by the target of an invocation.“ … After Binging few mins I got some clue what could …

How to fix – Exception has been thrown by the target of an invocation – VS2012 VS2010. Read more »