Often, I see people reporting "zzz fails if I'm not admin". Do I have to be machine admin to use SSIS? Well, absolutely no. Most SSIS tasks can be performed without being admin at all. Actually, I develop on Vista machine and I very rarely need to...

One of the mechanisms that SSIS data flow engine utilizes to achieve high performance is “back pressure”. Let’s consider a simple package with a source and destination. What happens if the source is fast and destination is slow? Say source is huge...

With first Katmai (SQL Server 2008) CTP out, I think it is time to blog about some performance and scalability improvements in this release......