31 Days of SSIS – SSIS Naming Conventions (31/31)

We’re at the thirty-first, and last, post for the 31 Days of SSIS.   The series started with an introductory post.  This series has been a collection of the things that I’ve picked up over the years in my work with SSIS.  I figured I’d end this series with a best practice that I’ve not often … Continue reading 31 Days of SSIS – SSIS Naming Conventions (31/31)

Presentations Materials From Last Week

Last week I spoke at the PASSMN meeting here in Minnesota and then via a webcast to the Edmonton PASS chapter.  For both nights the presentations seemed to go fairly well – especially given the e-mail requests for the presentation materials after the events. PASSMN Meeting Session: Error Logs and Deadlocks, Oh My Tired of … Continue reading Presentations Materials From Last Week

31 Days of SSIS – Importing Execution Plans (30/31)

Almost time to wrap up the 31 Days of SSIS.  We are down to just two more posts with today’s post being number thirty.  If you’re behind on this series, check out the introductory post. This morning’s one day late twenty-ninth post went over the use of the Export Column transformation.  Since we discussed that … Continue reading 31 Days of SSIS – Importing Execution Plans (30/31)

31 Days of SSIS – Exporting Execution Plans (29/31)

A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still coming out.  And if things go right, I’ll be caught up where I need to be by the end of the day.  If you’re behind on this series, check out the introductory post. File Export Requirements When considering … Continue reading 31 Days of SSIS – Exporting Execution Plans (29/31)

31 Days of SSIS – Jim Croce and the Foreach (File) Loop Container (28/31)

It’s Friday and I’m still taking Friday’s off in my 31 Days of SSIS blog series.  As I mentioned the last two Fridays, I got someone else to write the blog post instead.  I figured people would probably still be showing up, so I though it best to get someone on here writing. This time … Continue reading 31 Days of SSIS – Jim Croce and the Foreach (File) Loop Container (28/31)

31 Days of SSIS – Adding Some Delta Force (27/31)

Welcome to day twenty-seventh post of the 31 Days of SSIS.   We’re getting near the end now.  If you haven’t yet, I recommend reading the other posts, they can be found through the introductory post.  This series has been a collection of the things that I’ve picked up over the years in my work with … Continue reading 31 Days of SSIS – Adding Some Delta Force (27/31)

31 Days of SSIS – Small Package, Big Win (26/31)

Welcome to day twenty-sixth post of the 31 Days of SSIS.   We’re getting near the end now.  If you have not read the other posts, they can be found through the introductory post. This series has been a combination of my thoughts on practices for working with SSIS and proof of concept packages that represent … Continue reading 31 Days of SSIS – Small Package, Big Win (26/31)

Presenting on #SSIS to EDMPASS Today

Will you be in Edmonton today?  How about near a computer connected to the inter-tubes?  If so, you might be interested in joining the EDMPASS January user group meeting.  Colin Stasiuk (Blog | @BenchmarkIT) invited me to join the meeting today. The details for the meeting are Start Time: Wednesday, Jan 26, 2011 6:00 PM … Continue reading Presenting on #SSIS to EDMPASS Today

31 Days of SSIS – One Package, Unlimited Tables (25/31)

One day at a time and we have reached the twenty-fifth post in the 31 Days of SSIS.   If you enjoy this post, take a look at other posts in this series.  They can be found through the introductory post. Yesterday’s post demonstrated an SSIS package that connected one package to unlimited databases.  For today, … Continue reading 31 Days of SSIS – One Package, Unlimited Tables (25/31)

Time To Get Your #SQLRally Vote On! – Part 2

Now it’s week three of voting for the upcoming SQLRally.  This week, we are voting for the  Enterprise Database Administration & Deployment sessions for the conference.  Part “two” when we are on week three you may wonder?  Well that’s because I have a session listed in this track as I did in last week’s track … Continue reading Time To Get Your #SQLRally Vote On! – Part 2