Let's add Remedy by BMC to that list. The have tables that hold nothing but the next ID value for another table because they don't even use ID columns. Sure,...

Gotta love it when developers take a RDBMS and make it a DBMS, eh?

If this is the way the company thinks and you think you will have a hard time...

This doesn't stop someone with sysadmin rights from mucking with the data, though.

Sure, nothing will stop someone with sysadmin rights from mucking with the data if they want. They could...

"Friends help you move. Real friends help you move bodies"

"I've never excelled at golf. I'm not even that good with a tire iron. Though, I did get a hole in...

I fell out of my chair on that second one. Not PC, but funny.

Here are some of my favorites:

"I can only help one person a day. Today isn't your day. Tomorrow isn't looking good either"

"If you gave him a penny for his thoughts,...

Adam, I agree with you and I don't agree at the same time.

I consider myself more of a systems administrator who also knows SQL to the level a good...

New word for the dictionary:

Abnormalization: The process a DBA's brain undergoes when looking at a database created by someone who cannot spell SQL or thinks that T-SQL is what...

Exactly, Mike. That was the point I was trying to make.

You said it better.

I said "needlessly sticking to 4NF or 5NF isn't efficient" Perhaps I should have been clearer. Many databases I have worked with are not even 3NF, let alone 4NF or...

SQLBill, you are 100% right (as is everyone else who has been saying this). Microsoft, in its push to make its own technology more ubiquitous has made it so anyone with...

dataOverall, I liked the article but I have never, not really ever having applied for a "DBA" position instead of a "system administrator/dba" position, been asked questions like those. I...

Ha! That gives me an idea. Put this on a questionaire:

Rank yourself on a scale of 1-10 in the following 4 areas, keeping in mind that the data will be...

If you've got people dropping or wiping out data from production tables that frequently, perhaps you should look at tightening down security to prevent that? I mean, are the people...

Ok, I hate questions like this. (and I hate to be a nitpicker, but I can live with it)

CREATE TABLE DemoTabl

     ( clientno integer,

        dob datetime )

go

By default, creating the table...