PowerShell: Download List of SQL Server MVPs

This weekend, I was working on something that I will blog about later this week.  As part of that, though, I needed to download a list of all of the SQL Server MVPs that Microsoft publishes. A few times back, I just cut-n-pasted these down to get them all out quick and dirty.  After reading … Continue reading PowerShell: Download List of SQL Server MVPs

This Month… SSWUG Free SSIS Expo

A couple months back I mentioned the SSWUG Free Expo Event: Basic and Complex SSIS Features.  The time has crept by, more like flown by, and that expo is now this month on February, 18th. If you are interested in learning more about SSIS then now’s the time to get registered.  SSWUG is offering a … Continue reading This Month… SSWUG Free SSIS Expo

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)