Category Archives: Best Practices

SQL Server MVP Deep Dives

I’m not a SQL Server Most Valuable Professional anymore[1], but I was when this amazing project got underway, and I am proud to contribute as an author on SQL Server Integration Services. SQL Server MVP Deep Dives is a unique … Continue reading

Posted in Best Practices, Book, Conference, SQL Server, SSIS, T-SQL | 3 Comments

SSIS Package Templates: The Good, The Bad and The Ugly.

This is one of those “I could have sworn I blogged on this topic years ago” posts. I speak to this topic whenever I’m presenting on SSIS development best practices, and with my half-day mini-seminar in Stockholm last week[1] I … Continue reading

Posted in Best Practices, BI, dev, SSIS | 6 Comments

SSIS and the Package ProtectionLevel Property

This is another one of those “I could have sworn I blogged on this years ago” posts.[1] I was looking for something I’d already written that discussed the ProtectionLevel property of the SSIS Package, but search as I might I … Continue reading

Posted in Best Practices, BI, Deployment, SSIS | 9 Comments

SSIS Development and Source Code Control

In my personal best practices for SSIS development, I claim that we need to treat SSIS packages like code. When I give presentations on this topic, I have a slide that elaborates and talks about how we must use source … Continue reading

Posted in Best Practices, BI, dev, SSIS | 3 Comments

Indexes and SSIS Data Flow Performance

Wow – it’s been a while, hasn’t it? As you may know, I took a job with Microsoft back in October. It’s been a fun (and insanely busy) five months; the work is challenging and diverse, the team I work … Continue reading

Posted in Best Practices, Performance, SQL Server, SSIS | 1 Comment

Know Your Data… Werewolves

(That’s right. Werewolves.) Over a year ago, I posted a list of SSIS best practices, and I’ve presented on this topic a dozen or more times since then at conferences and user groups and seminars. One of these best practices … Continue reading

Posted in Best Practices, BI, Quote, SSIS | 1 Comment

Choosing the "Right" SSIS Configuration Location

One of the questions I get asked quite often boils down to this: "Should I store my SSIS configuration data in SQL Server or in XML configuration files?" And my every-so-helpful answer usually is: "Yes!"[1] That’s right – very accurate, … Continue reading

Posted in Best Practices, BI, Conference, Deployment, SQL Server, SSIS | Leave a comment