Monthly Archives: August 2009

Microsoft SQL Server 2008 – Business Intelligence Development and Maintenance Self Paced Training Kit and Certification Plans

I have just finished the training kit and will be spending the next week and a half or so going through the practice tests, reviewing the books on-line pages, going through the references in the back of the certification book … Continue reading

Posted in SQL | Tagged , , | 2 Comments

Maintainability / Readability of SSIS Packages and Jobs

This past week has held many issues with a recently released application under the purview of the DBA team.  What has really separated this from a host of other jobs and procedures which they watch over is that this application … Continue reading

Posted in SSIS | Tagged , | Leave a comment

Certification Part Two

I’ve just finished a few novels (I read The Reader, An Empire Unacquainted With Defeat, Do Androids Dream of Electric Sheep and Free Live Free) after taking the last certification, which was what I told myself I would do before … Continue reading

Posted in General Ramblings | Tagged , , | Leave a comment

SSIS – Retain Values from Previous Rows

There are times when data is read in a fashion that needs to be examined and compared based on the value(s) of the previous record(s) for a particular grouping.  For example, one might have the following data which does not … Continue reading

Posted in SSIS | Tagged , | 2 Comments