Whoa!!!  I recently worked for a company developing a product that we had to completely re-design because it was rejected by a major prospective client for using FOUR databases (which...

Excellent QOD; that's exactly the kind of thing I want to see more of.  No vague answers and it forces you to either know it or do some reasearch and learn...

Just curious, if you're currently the only DBA why aren't you going to be involved in the interviewing process?  Sounds like a management SNAFU to me...

If you're really hardcore, sit the candidates down in front of a machine that you've prepared earlier w/ a database with some problems.  Give them a task list, ranging from very simple...

What's "formally trained" mean?

These answers were highly suboptimal.  Modify "a" registry setting?  Which one?  Shall we select settings at random until something either works or we get fired?  Furthermore, not all firewalls have...

quote:

---

Are there any justifications for these practices?

---

Yes; laziness and lack of understanding of the relational...

By the way, just looked at the thread you posted and I feel that there should NOT be two lookup tables in that situation; statuses of court cases are the...

sumlin,

Perhaps you have implemented these things in the field in different ways than what I've seen. Said performance draining bloat and data dictionary issues are the results that I...

sumlin,

I said it would cause problems down the road, perhaps not initially; unless you've developed these dozens of applications for one gigantic company, I can only assume you weren't around...

sumlin,

Doesn't your technique still violate 1NF? You are representing different entity types in a single column. How is this any better or less complex than maintaining individual lookup...

I don't agree with the content of this article at all. It's a cute idea, and will probably reduce the size of your database schema -- at the expense...

As keithh said, DTS packages have versioning built in. Sprocs do not. If you want versioning, use a source control package! The suggestion to use the instancing...

I learned my lesson last week about re-reading the question once the website pops up! Don't forget!

Brian,

That's certainly not what my e-mail said. Maybe forum admins get the more detailed version of the question?

The e-mail I received stated:

"What is the best way to prevent hackers...