The "organic" nature of database development has caused us to have this in our projects.

Phase 1 - Inexperienced developers. Poor coding practice. Column names and data types from source data...

I have a password safe app on my phone that doesn't integrate with anything. I find it highly useful to keep track of all the various sites where I have...

Rumor has it my department has a training budget. It's a rumor because no one has ever been sent off for training. We ask and we're told to 'find some...

Ah yes. Bad bosses. The difficulty in leaving a job because of a bad boss is there's no guarantee your next one will be better if not worse. 

I've...

And this is why I drink....

Four months ago I told my boss that I need to tune some queries in a datamart because they were using massive CTEs...

If you're doing this during a data flow you can use the Derived Column transformation. That will also let you get it into the correct data type downstream.

Thanks for the deceptively simple question. I know I'll use this reminder going forward. Until I forget again..

I too cannot post pictures of my workspace (or probably shouldn't so I'm not taking the risk) but I stopped personalizing my desk many jobs ago.

Having said that...

You already marked this as answered but look into using the OnError Event Handlers when creating your packages. It's the only place that has the system variable with the full...

There's a lot of difference between being disappointed (the meeting didn't have treats) and being excluded (the project I've been working on for the last six years is on the...

This is a pretty basic thing (not saying anything about your skills so please don't take it that way).

You want to find new records. Look into the LEFT...