Category:Uncategorized

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

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?

… 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…

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

I’m honored to present two sessions Friday 10 Jul 2015 at CodeStock 2015! At 10:15 AM, right after the keynote by THE Scott Hanselman, I’m presenting Designing an SSIS Framework. At 2:40, I’m presenting SSIS 2014 Data Flow Tuning Tips and Tricks. I hope to see you there! :{> Learn more:  Stairway to Biml Linchpin …
Continue reading Presenting at CodeStock 2015!

I’m honored to present “SSIS Data Flow Performance Patterns” at the Charlotte BI Group 7 Jul 2015! In this session, I discuss Data Flow Task internals and patterns that improve SSIS 2014 Data Flow performance in your data integration enterprise: Incremental Loads, Blob Pyramid, and Type 2 New + Updated Rows. Plus, I tell funny …
Continue reading Presenting SSIS Data Flow Performance Patterns at Charlotte BI Group 7 Jul!

With mixed emotions, I just read The End of an Era – SQLFool scripts are now open-sourced. After two book projects together, I admire Michelle (New Blog | @SQLFool) immensely. More than that, I consider her a friend. It’s exciting to (try to) keep up with all the cool stuff Michelle’s working on, and I …
Continue reading So Long, and Thanks for All the Scripts!

It’s your turn. You start blogging. You cannot start in July 2007 like I did – even if you have a Delorean. But you can start in July 2015. Here’s the thing: In 2023, eight more years will have passed. Will you have posted 700 blog posts by then? You can. How do I know? …
Continue reading 701

Adam Machanic (Blog | @AdamMachanic) emailed me way back in July 2007 and asked if I’d be interested in joining the awesome crew blogging at SQLBlog.com. I was honored to be asked and loved the idea of joining the bloggers here (“A group of really smart SQL Server bloggers… plus me”). And wow – this …
Continue reading 700

Here’s a list of upcoming training opportunities for people wanting to learn more about SQL Server Integration Services (SSIS) and Business Intelligence Markup Language (Biml): Office Hours: Is Biml Right for You? Live Q & A Webinar 27 May 2015 at 12:00 PM EDT. Register, it’s FREE! Advanced SSIS Design Patterns and Automation with Biml …
Continue reading Want to Learn More About SSIS and Biml? Upcoming Training Opportunities!