Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2011

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… Read more

0 comments, 569 reads

Posted in StrateSQL on 31 January 2011

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

31 Days of SSIS

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… Read more

0 comments, 1,285 reads

Posted in StrateSQL on 31 January 2011

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

31 Days of SSIS

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,… Read more

2 comments, 1,059 reads

Posted in StrateSQL on 30 January 2011

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

31 Days of SSIS

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… Read more

0 comments, 358 reads

Posted in StrateSQL on 28 January 2011

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

31 Days of SSIS

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… Read more

1 comments, 765 reads

Posted in StrateSQL on 28 January 2011

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… Read more

1 comments, 225 reads

Posted in StrateSQL on 27 January 2011

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…

Read more

0 comments, 283 reads

Posted in StrateSQL on 26 January 2011

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

31 Days of SSIS

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… Read more

4 comments, 806 reads

Posted in StrateSQL on 26 January 2011

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… Read more

1 comments, 218 reads

Posted in StrateSQL on 25 January 2011

PASSMN January Meeting Today

Minnesota SQL Server User Group (PASSMN) will be meeting today.  Come down and learn about SQL Server with Kalen Delaney (Blog | @SQLQueen) and the rest of our group.

Event Details

Date / Time: 1/25/2011 5:00:00 PM

Location: 8000 Norman Center Drive, Bloomington, MN  55437

Agenda:

  • 4:30-5:00 :…

Read more

1 comments, 194 reads

Posted in StrateSQL on 25 January 2011

31 Days of SSIS – One Package, Unlimited Databases (24/31)

31 Days of SSIS

Another day, another blog post all about SSIS in my continuing journey through 31 Days of SSIS.  A list of the other posts in this series can be found in the introductory post.  If you haven’t had a chance to read through that, I… Read more

5 comments, 583 reads

Posted in StrateSQL on 25 January 2011

31 Days of SSIS – Generating Row Numbers (23/31)

31 Days of SSIS

It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days of SSIS blog series.  A list of the other posts in this series can be found in the introductory post.  If you haven’t had a chance to read… Read more

0 comments, 1,274 reads

Posted in StrateSQL on 24 January 2011

PASSMN January Meeting This Week

Don’t forget – if you are in Minnesota this week the Minnesota SQL Server User Group (PASSMN) will be meeting on Tuesday.  Check us out because we’ll have Kalen Delaney (Blog | @SQLQueen) coming in for a presentation. 

Event Details

Date / Time: 1/25/2011 5:00:00 PM

Location: 8000… Read more

0 comments, 169 reads

Posted in StrateSQL on 23 January 2011

31 Days of SSIS – Data Flow Expressions (22/31)

31 Days of SSIS

Today, we continue on with the 31 Days of SSIS blog series.  Yesterday’s post was on the use of expressions with Precedence Constraints and how to control the Control Flow.  Today, we’ll venture a little further in with the use of expressions, and a head… Read more

1 comments, 1,220 reads

Posted in StrateSQL on 22 January 2011

31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31)

Remember, what I said last Friday?  I’m going do it, again.  Which means, I’m taking the day off.  There will still be a 31 Days of SSIS post, you’re reading it right now.

This post was being written by Chris Fish (LinkedIn).  He’s another of my co-workers… Read more

1 comments, 337 reads

Posted in StrateSQL on 21 January 2011

Now Let’s Vote for 24 Hours of PASS

Yesterday, I wanted you to vote for some SQLRally sessions, mine included.  Today, let’s vote for the sessions for the next 24 Hours of PASS.

If you don’t recall, the next 24 Hours of PASS will be celebrating Women’s History Month.  And because of this, the entire slate… Read more

1 comments, 194 reads

Posted in StrateSQL on 20 January 2011

31 Days of SSIS – No More Procedures (20/31)

Time to shift off of configurations and environments and talk more about SSIS packages and best practices.  If you haven’t been following this series and are just joining in, we are at day 20 of the 31 Days of SSIS.  Now that is out of the way, let’s move… Read more

6 comments, 840 reads

Posted in StrateSQL on 20 January 2011

31 Days of SSIS – DTSConfig Configuration (19/31)

31 Days of SSIS

The last two posts in the 31 Days of SSIS talked about the use of environmental variables and SQL Server configurations.  Between those two types of configurations, you can cover most situations where you need to configure an SSIS package.

There is one more type… Read more

0 comments, 601 reads

Posted in StrateSQL on 20 January 2011

Time To Get Your #SQLRally Vote On!

It’s week two of voting for the upcoming SQLRally.  This week, we are voting for the Database & Application Development sessions for the conference.  You might think… “hey, should I even vote?  I’m not sure I can attend.”  I say, YES!  The SQLRally is a community event where the… Read more

1 comments, 175 reads

Posted in StrateSQL on 19 January 2011

31 Days of SSIS – SQL Server Configuration (18/31)

31 Days of SSIS

The last post in the 31 Days of SSIS talked about the use of environmental variables.  As I mentioned in that post, environmental variables are great for values that are specific to individual environments

One problem with environmental variables that I mentioned is often the… Read more

4 comments, 946 reads

Posted in StrateSQL on 19 January 2011

Older posts