Presenting SSIS 2014 Data Flow Tuning Tips and Tricks at Triad PASS BI 25 Aug 2015!

I am honored to present SSIS 2014 Data Flow Tuning Tips and Tricks to the Triad PASS BI chapter in Winston-Salem 25 Aug 2015. Do you want SSIS to go fast? This session is for you! Attend and learn techniques for developing, instrumenting, monitoring, and managing SSIS 2014 Data Flow performance in your data integration …
Continue reading Presenting SSIS 2014 Data Flow Tuning Tips and Tricks at Triad PASS BI 25 Aug 2015!

SSIS Design Pattern: Access Parent Variables from a Child Package in the SSIS Catalog

I am regularly asked about passing variable values between SSIS packages. Tim Mitchell (Blog | @Tim_Mitchell) wrote an excellent Notes from the Field article for the SQL Authority blog called SSIS Parameters in Parent-Child ETL Architectures. Before the first version of the SSIS Catalog was even released, Jamie Thomson blogged about The new Execute Package …
Continue reading SSIS Design Pattern: Access Parent Variables from a Child Package in the SSIS Catalog

What Customers Want

Not once, in my combined years of direct employment by enterprises or consulting, has a customer contacted me about an issue about the grain of their date dimension in their enterprise data warehouse. Not one single time. I haven’t been contacted about cardinality either. Or trouble with execution threading models. Nope. Not ever. Instead, I’ve …
Continue reading What Customers Want

Validate SSIS Scripts Before Closing the VSTA Window

I love learning new stuff! I’m blessed to work with a talented group of individuals at Linchpin People. We often work together in teams and I have to admit, I cherish those times. One reason is I learn something new. Every. single. time. For years, I’ve validated SSIS Script Task code by searching for red …
Continue reading Validate SSIS Scripts Before Closing the VSTA Window

Presenting Using Biml as an SSIS Design Patterns Engine at Hampton Roads .Net UG 11 Aug

I am honored to present Using Biml as an SSIS Design Patterns Engine at the Hampton Roads .Net Users Group (@HRNUG) 11 Aug 2015! Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of Biml in …
Continue reading Presenting Using Biml as an SSIS Design Patterns Engine at Hampton Roads .Net UG 11 Aug

Interested in Training – From Zero To SSIS?

I’ve received a couple inquiries recently about SSIS training for people new (or new-ish) to data integration. I have delivered a course called From Zero To SSIS in the past, but not recently. If you are interested in this training, please contact me by clicking the Email link in the upper right frame. If enough …
Continue reading Interested in Training – From Zero To SSIS?

SQL Formatting Matters…

… to some folks more than others. We likely all have stories about working with folks who care a lot about the format of their SQL statements. I’ve worked with a lot of database developers and analysts. I cannot say SQL formatting distinguishes the good from the bad (or ugly), but I have noticed the …
Continue reading SQL Formatting Matters…