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

Archives: December 2010

2010 Recap

As a part of a recap on the year that was 2010, I should start with a recap of my goals.  For that review I had to go back to my Q3 review.  As I looked it over, I found that there was nothing really different from that review… Read more

4 comments, 270 reads

Posted in SQL RNNR on 28 December 2010

SSIS Multiple File Export

Have you ever needed to export different data sets to different flat files?  Each of these data sets could be customer information for different clients – but they all require the same fields.  I have run into this requirement a few times and have found that it is not as… Read more

0 comments, 701 reads

Posted in SQL RNNR on 28 December 2010

Powershell, Me and the MCM part II

Last week I posted the first part of this series.  I thought it would be a good idea to give a little follow-up on how my foray into Powershell as I attempted to download this videos.

Attempt 1:  Failed miserably.  I did not have enough disk space and thus only… Read more

0 comments, 318 reads

Posted in SQL RNNR on 20 December 2010

Powershell, Me and the MCM

If you haven’t heard yet, Microsoft has made some significant changes to the MCM program.  The changes make the certification more accessible to the masses.

You can read more about that from sources such as the following:

  1. Grant Fritchey
  2. Jason Strate
  3. Glenn Berry
  4. Microsoft

This post is not so much… Read more

2 comments, 321 reads

Posted in SQL RNNR on 16 December 2010

Tis the Season

This month has been quite the month for change in my family.  The changes that we are experiencing did not end with the birth of our baby girl two weeks ago.  My employment is changing too.  Along with the employment change comes another change – moving back to Utah.

My… Read more

0 comments, 223 reads

Posted in SQL RNNR on 15 December 2010

T-SQL Tuesday #13 – Business Requirements

Business Requirements

We have made it yet another month and to yet another episode in the continuing saga known as TSQL Tuesday.  This month we are being hosted by Steve Jones ( Blog | @Wayoutwest ) of SqlServerCentral fame.  Steve has asked us to speak a little bit about business… Read more

0 comments, 266 reads

Posted in SQL RNNR on 14 December 2010

Wait Stats resources

Today I was out and about looking for past roundups on TSQLTuesday.  While doing that, I came across a post from Paul Randal (BlogTwitter) about wait stats.  The thing that strikes me about this post is the great query and the excellent references to more resources.… Read more

0 comments, 335 reads

Posted in SQL RNNR on 13 December 2010

SSIS Job Execution

While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time as parts of release cycles), I ran into self-imposed requirement.  I was attempting to create a process that would perform the entire process consistently.  Amongst the items that I needed… Read more

0 comments, 317 reads

Posted in SQL RNNR on 13 December 2010

SQL Confessions

I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago and am finally getting around to putting it together.  The idea came about while I was struggling with a problem at work and trying to meet the requirements in the… Read more

0 comments, 227 reads

Posted in SQL RNNR on 13 December 2010

Bundle of Joy

After baking for 9 months, our bouncing baby girl has finally arrived.  She arrived Thursday Dec 2, 2010 at 8:28 AM (PST).  There were no complications and the delivery went smoothly.  Family is doing well.  My wife is doing well.  And baby is doing well.  Our newborn came in at… Read more

7 comments, 228 reads

Posted in SQL RNNR on 9 December 2010

December 2010 SSSOLV Reminder

Here is a quick reminder and a repost of the announcement from last week.

This month we will be broadcasting the meeting once again.  This month the technology bug will not bite us like last month.  I can feel it – we are bound for a problem free evening .

Read more

0 comments, 231 reads

Posted in SQL RNNR on 8 December 2010

December 2010 S3OLV Meeting

It is amazing how the months just seem to fly by these days.  I probably say that every month.  It seems appropriate though.

This month we will be broadcasting the meeting once again.  This month the technology bug will not bite us like last month.  I can feel it –… Read more

0 comments, 220 reads

Posted in SQL RNNR on 1 December 2010