Monthly Archives: July 2009

ODS Indexes, when should we trash them?

It is said that a fair majority of the ETL process is spent dealing with indexes.  So, how can we decide when to destroy an index and then recreate it after the table is loaded?  Do you maintain these indexes … Continue reading

Posted in SSIS | Tagged , | Leave a comment

MCTS – Database Development

Today I took and passed the 70-433 database development Microsoft certification exam.  All in all, it was not a bad experience.  I think that I started to look at the prep kit about three weeks ago; spending, on average, about … Continue reading

Posted in SQL | Tagged , , | Leave a comment

70-433 Certification

Well, I’ve spent quite a few hours over the last several weeks trying to study up for the 70-433 database development microsoft certification exam.  I finally committed to taking it Thursday.  Now, I just have to cram for the next … Continue reading

Posted in SQL | Tagged , , | Leave a comment