Category:Uncategorized

I have waited (again) until the last minute to submit presentations for the PASS Summit. I’m submitting “Using Biml as an SSIS Design Patterns Engine” – a presentation based on a chapter in SSIS Design Patterns and Levels 2-4 of the Stairway to Biml – and I am pleasantly surprised to see Biml included in …
Continue reading Biml: An Official Topic for PASS Summit 2015 Presentations

I am honored to work alongside TechniTrain to deliver SQL Server Integration Services Design Patterns in London 7-10 Sep 2015! Register before 31 Mar to save £100. Who is it for? The target audience for this course is intermediate SQL Server Integration Services developers (or quick learners) who wish to learn best practices and design …
Continue reading Announcing SSIS Design Patterns Training in London 7-10 Sep 2015!

I am honored to present SSIS Data Flow Tuning Tips and Tricks at Midlands PASS 16 Apr 2015! SSIS 2014 Data Flow Tuning Tips and Tricks 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 …
Continue reading Presenting at Midlands PASS 16 Apr 2015!

Fri, Mar 6, 2015 at 8:44 AM Hi Trello People, I think our organization has Trello Gold, but I cannot access features I think I should be able to access. I cannot change backgrounds, I cannot attach emails to cards. Help, Andy Fri, Mar 6, 2015 at 11:26 AM Hi Andy, Thanks for writing to …
Continue reading Customer Service Done Well

SQL Server Integration Services (SSIS) is built to move data. SSIS ships with features to support the secure transmission of data. In this series, my goal is to promote awareness of these features and advocate for their use. SSIS Connection Managers In Secure Connections Management in SSIS, Part 1, I demonstrated configuring an SSIS Connection …
Continue reading Secure Connections Management in SSIS, Part 2

My friend George Squillace (LinkedIn) shares this great post and cool SSIS Catalog Visualizations. Enjoy! :{> Learn more: Advanced SSIS Training with Tim Mitchell and Andy Leonard in Dallas, TX 9-11 Mar 2015 Linchpin People Blog: SSIS Stairway to Integration Services

Earlier this month, I decided to take a break from Twitter and Facebook. A couple of you noticed (I’m ok, Mom. Really!) so I decided to share this post. I continue to post updates about articles, blog posts, and presentations at LinkedIn, and I’m (obviously) still blogging. I encourage everyone interested in the goings-on at …
Continue reading Social Media and Me

SQL Server Integration Services (SSIS) is built to move data. SSIS ships with features to support the secure transmission of data. In this series, my goal is to promote awareness of these features and advocate for their use. SSIS Connection Managers Let’s begin by examining ways to connect to a database – any database – …
Continue reading Secure Connections Management in SSIS, Part 1

Brevity. :{> Learn more:

SSIS Catalog Environments– Step 20 of the Stairway to Integration Services is live at the Stairway to Integration Services site at SQL Server Central! Enjoy! :{>