I also agree that hiring Juniors is a way to go because, as David said, they don't come with pre-conceived notions or established habits that are difficult to correct. I...

I agree with you, Grant! If we have an attitude of gratitude, we'll have a better outlook on life! While our circumstances won't change, our outlook and approach will change...

Ya beat me to it!

The entire concept of psychology is to help people. It's the sick and depraved who use such knowledge to target the inherent goodness in...

An interesting database analogy, but quite apt. It's also good that you stuck to your guns and didn't let them pressure you into action before you were ready. I have...

Steve, I appreciated your comment: "Perhaps the Lucid developers are under pressure to get features out, but it seems that I've encountered more than a few things that could (should?)...

Yeah, I'm scratching my head on this one. Due to case insensitivity, I would expect all 10 rows to return, so I selected 10. I am surprised that the "correct"...

Over 20 years ago, I was asked to administer the phone system. It was antiquated and had a separate system for voicemail. The only way to connect to them was...

HTML didn't like the correct answer: <Steve Jones>

• This reply was modified 5 months, 1 weeks ago by Aaron N. Cutshall.

As a data architect, I'm always preaching about using consistent standards to enforce names, data types, etc. The value of a standard isn't in the method of naming or data...

Crap. I didn't notice that the procedure was created in the ETL schema.

Unfortunately, none of the answers will work as they all return NULL since they fall outside of the acceptable range of values for NCHAR (0 through 0xFFFF).

• This reply was modified 10 months, 1 weeks ago by Aaron N. Cutshall.

If it is an ETL load that takes an hour AND runs during company downtime and I can get it down to 5 minutes, yes it is a HUGE...

I have to say that when it comes to refactoring code, it's usually my own code that I refactor. This is typically because I've learned more since I originally wrote...

@Ronald, you have a point that most modeling tools focus only on the physical model. There are some that also claim to have logical models, but they are not true...