I remind my children who live at home – the "junior engineers" – to deal with the things they have in their hands while they have them in their hands. Why? Because it’s inefficient to put something down only to pick it up later and put it where it belongs. Like all rules, there are …
Continue reading While You Have It…
Author:Andy Leonard
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
Own the SSIS Design Patterns E-Book for $10–Today Only!
Own the SSIS Design Patterns (2nd edition – updated for SSIS 2014) ebook today for just $10! :{> Learn more: Stairway to Biml Linchpin People Blog: SSIS Stairway to Integration Services
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…
Stairway to Integration Services Level 21 is Live!
Extending Custom Execution in the SSIS Catalog – Level 21 of the Stairway to Integration Services is now live at SQL Server Central! Enjoy! :{> Learn more: Stairway to Biml Linchpin People Blog: SSIS Stairway to Integration Services
