Author Archives: jwelch

Presentations at Atlanta’s BI Edition SQL Saturday

Posted on January 11, 2016 by jwelch

I presented this weekend at SQL Saturday #477 in Atlanta. It was a great event, very well organized. I appreciate all the attendees at my sessions – there were some great questions and comments. I promised that I’d publish my … Continue reading →

Posted in Presentations, SQL Saturday | Tagged , , | Comments Off on Presentations at Atlanta’s BI Edition SQL Saturday

You Don’t Have Time for Testing?!

Posted on September 3, 2015 by jwelch

I wrote a post for the Pragmatic Works blog that I thought would be interesting for my readers, so I’m posting a teaser here. If you want to read the whole post, go here. I’ve been a big advocate of … Continue reading →

Posted in Professional Development, Testing | Tagged , | Comments Off on You Don’t Have Time for Testing?!

Advanced Scripting in SSIS

Posted on August 17, 2015 by jwelch

Last week I presented a session on Advanced Scripting for SSIS for Pragmatic Works. Thanks to everyone who attended, and all the great questions. I’ve had a few requests for the samples I used, so I wanted to make those … Continue reading →

Posted in Presentations, SSIS | Tagged , , | Comments Off on Advanced Scripting in SSIS

Follow Up for Continuous Delivery Presentation at CBIG

Posted on May 7, 2015 by jwelch

I presented Continuous Delivery for Data Warehouses and Marts at the Charlote BI Group Tuesday night. They have a great group there and I look forward to going back. This is one of my favorite topics, and I always get … Continue reading →

Posted in Presentations, SSAS, SSIS, User Groups | Tagged , | Comments Off on Follow Up for Continuous Delivery Presentation at CBIG

Going to the PASS Business Analytics Conference

Posted on April 7, 2014 by jwelch

I found out recently that I’ll be able to attend the PASS Business Analytics Conference this year, which I’m pretty excited about. Also, I’m not presenting at this conference, so I will actually get to relax and enjoy the sessions … Continue reading →

Posted in Uncategorized | Comments Off on Going to the PASS Business Analytics Conference

Q & A From “Unit Tests for SSIS Packages”

Posted on April 8, 2013 by jwelch

I did a webinar this week for Pragmatic Works’ “Free Training on the T’s”. The topic was “Unit Tests for SSIS Packages”. If you attended, thanks for taking the time! If not, the recording is now available at the link … Continue reading →

Posted in Presentations, SSIS | Tagged , | Comments Off on Q & A From “Unit Tests for SSIS Packages”

Where’s John These Days?

Posted on February 20, 2012 by jwelch

Apologies for the lack of updates to the blog recently. It’s been a very busy time, but hopefully things will settle down a bit now. Exciting news today (for me at least)! It was my first day as a Pragmatic … Continue reading →

Posted in Events | Tagged , , | Comments Off on Where’s John These Days?

Checking Whether a Character is Numeric

Posted on August 30, 2011 by jwelch

Check whether a specific character is numeric in an SSIS expression Continue reading →

Posted in SSIS | Tagged , | Comments Off on Checking Whether a Character is Numeric

Naming Columns for the Script Component

Posted on August 18, 2011 by jwelch

Naming columns is important for the Script component Continue reading →

Posted in SSIS | Tagged , | Comments Off on Naming Columns for the Script Component

Using OLE DB Connections from Script Tasks

Posted on August 17, 2011 by jwelch

Use OLE DB Connections from Script Tasks in SSIS Continue reading →

Posted in SSIS | Tagged , | Comments Off on Using OLE DB Connections from Script Tasks