SSIS multiple Instances Package Store in SSMS

Recently I installed both SQL 2008 R2 and SQL 2012 on my new laptop. I installed SQL 2008 R2 as default and 2012 as named instance. Post in...

Data warehousing concepts

Information Technology (IT) has historically influenced organizational performance and competitive standing. The increasing processing powe...

WCF Architecture Explained

Windows Communication Foundation (WCF) simplifies development of connected applications through a new service-oriented programming model. I...

Why SQL Server 2008?

Reasons To Upgrade Upgrading to 2008 will give an additional 3 years of support. So you’re looking at 7-8 years of support as opposed...

Passing Data to Thread in .Net

In most real world use of threading, you will need to pass information to individual threads. To do this you will need to use a new delegat...

3 Ways of Migrating DTS to SSIS 2005

Options for migrating DTS to SSIS 2005 are - Execute DTS 2000 Package Task - Use the Execute DTS 2000 Package task to invoke DTS packa...

FxCop Custom Rules

FxCop is one of the legendary code review tools which help us automate reviews using set of rules against compiled assemblies. It comes wit...