About a year ago, I started playing around with CLR and my desire to disable xp_cmdshell for my clients.  As a result, I had created the CodePlex project FileSystemHelper.  I blogged about it back then and had meant to get back to it with a number of updates but… Read more

SSWUG Free Expo Event: Basic and Complex SSIS Features virtual conference is today!  There’s a chance that you can probably still get registered and I’d recommend doing so.

There will be four SSIS sessions that will cover a variety of topics, but you’ll get some of the following through the… Read more

She can dig it!
D Sharon Pruitt

A few PASS Summit’s ago, I became interested in the information available in the Plan Cache.  As part of that interest, I started digging into the plan cache to  find out what is there and available to be pulled out.

Some of those… Read more

You might wake up one day soon and think, “Hey, wouldn’t it be cool to write a month long blog series on so-and-so!”  It’s been done before, some examples are:

• Glenn Berry (Blog |@GlennAlanBerry) with A DMV A Day
• Paul Randal (Blog | @PaulRandal) with…

Read more

Do you know about congenital heard defects (CHD)?  Did you know that February 7-14 is the week dedicated to making people more aware of these defects?  It is the last day of that week and I’d like to take a few minutes to dedicate a post to this issue. 

Every… Read more

PASSMN meeting is this week on Tuesday.  Without further ado…

Meeting Details

Here are the details on the meeting location and time:

• Date: February 15th, 2011
• Time: 3:00 – 5:00 PM
• Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437

Please, RSVP so that we know how much food… Read more

She can dig it!
D Sharon Pruitt

It’s the eighth post in the plan cache series.  I hadn’t expect to take as many days off from this due to the 31 Days of SSIS, but that one had a stricter time table that I was following.  Though now… Read more

This past Wednesday I took a drive down to the Iowa SQL Server Users Group meeting.  It was a bit of a drive but I got a chance to hang out with a fellow Digineerian on the way there and talk about solutions.

I really… Read more

Last month, I published the 31 Days of SSIS blog series.  As a conclusion to that series, I wanted to post a wrap-up post, but quite honestly I was a little out of steam on February 1.

I wanted to thank those that have read or… Read more

A while back, I started a twitter list of SQL Server MVPs.  I wasn’t really sure why, but I just thought it would be interesting.  After a couple months of putting it together, Rob Farley (Blog | @Rob_Farley) challenged me to see if I could find more… Read more

If you are looking for a change to get together with other SQL Sever professionals in February to talk about High Availability, then come join PASSMN.  We are the Minnesota SQL Server user group that meets in Bloomington, MN.

This is an opportunity to learn about current and upcoming… Read more

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

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

In case you missed it last week, PASS has announced the speaker lineup for the next 24 Hours of PASS.  As you are hopefully aware, this next conference will be celebrating Women’s History Month.  Due to this all of the presenters will be women from the SQL Server… Read more

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