Category:Uncategorized

Apologies. My first edition of this post copied outdated links to this series. I have corrected the links but left the comments pointing out my earlier error. Thank you to those who let me know! :{>  A while back I asked myself: “Self, do you think it is possible to create a custom SSIS 2012 …
Continue reading [Re-] Updated: Creating a Custom SSIS 2012 Task

Per Thomas LaRock’s post titled Board of Directors Election Update on the PASS Blog: All PASS members who have not yet received a ballot and who had an existing profile as of June 1, 2014, will be given the opportunity to receive a ballot by updating their profiles before October 5, 2014, at midnight PDT. …
Continue reading Reminder: If You Want to Vote in the PASS Board of Directors Election, You Have 6 Days…

I am impressed with the response of PASS leadership to the controversy surrounding the 2014 Board of Directors election. Others have covered the topic much better than I will here, but a short version is PASS responded to the PASS Board 2013 election controversy (members with multiple email accounts receiving multiple ballots) by requiring members …
Continue reading Well Done, PASS Leadership

I am honored to announce Advanced Integration Services will be delivered in cooperation with  in Aarhus, Denmark 18-20 Nov 2014. Target Audience The target audience for this course is intermediate SQL Server Integration Services developers (or quick learners) who wish to learn best practices and the more advanced stuff, and those who wish upgrade their …
Continue reading Join me for 3 Days of SSIS Training in Denmark – Advanced Integration Services 18-20 Nov 2014

I am honored to present Using Biml as an SSIS Design Patterns Engine at SQL Saturday 323 – Paris 13 Sep 2014! If you will be in the Paris area 13 Sep, read this blog, and want to learn more about Business Intelligence Markup Language (Biml), stop by and say “Hi!” :{>

Mike Walsh (blog | @Mike_Walsh) tagged me in his post, 4 Attitudes I Wish I Had Earlier as a DBA. You should read Mike’s post, it’s filled with helpful and good advice and tells cool (and not-so-cool) stories. I admire Mike’s transparency. I struggle with the four areas Mike already covered – Work/Life Balance, Empathy, …
Continue reading Attitudes I Wish I Had Earlier

I am honored to present “Using Biml as an SSIS Design Patterns Engine” to SQL Midlands in Birmingham 11 Sep 2014 starting at 18:15! As at SQL Supper the evening before, the other presenter is my esteemed friend, Chris Webb (@TechniTrain). Chris’ session is titled, “Everything you wanted to know about Power BI but were …
Continue reading Presenting on Biml to the SQL Midlands in Birmingham (UK) 11 Sep 2014!

I’m honored to be one of the presenters at the 10 Sep 2014 SQL Supper, which starts at 18:00. The other presenter for the evening is my esteemed friend, Chris Webb (@TechniTrain). Chris will be presenting a Q&A session titled “Chat to Your Data with Power BI.” My session is called “SSIS 2014 Data Flow …
Continue reading Presenting at SQL Supper in London 10 Sep 2014!

A few seats remain for my course SQL Server Integration Services 2012 Design Patterns to be delivered in London 8-11 Sep 2014. Register today to learn more about: New features in SSIS 2012 and 2014 Advanced patterns for loading data warehouses Error handling The (new) Project Deployment Model Scripting in SSIS The (new) SSIS Catalog …
Continue reading SSIS Design Patterns Training in London 8-11 Sep!

Earlier this week, the Professional Association for SQL Server (PASS) announced speaker and session selections for the Summit 2014 and there was spirited community feedback, questions, and debate. I offer the following analysis and opinions: In Defense of PASS… Full disclosure: I was selected to present this year and have been selected to present for …
Continue reading PASS and Summit 2014 Session Selections