Viewing 15 posts - 1 through 15 (of 257 total)
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...
October 8, 2019 at 7:28 pm
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...
June 27, 2019 at 2:31 pm
October 23, 2018 at 8:09 am
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...
October 23, 2018 at 8:07 am
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.
October 22, 2018 at 9:25 am
October 22, 2018 at 9:16 am
I agree with all of the reasons given for use of surrogate...
October 1, 2018 at 8:34 am
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...
August 14, 2018 at 1:59 pm
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.
August 14, 2018 at 1:49 pm
Thanks for the deceptively simple question. I know I'll use this reminder going forward. Until I forget again..
June 13, 2018 at 10:25 am
June 11, 2018 at 9:01 am
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...
May 29, 2018 at 7:29 am
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...
May 22, 2018 at 11:16 am
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...
May 16, 2018 at 10:00 am
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...
May 8, 2018 at 8:27 am