I just realized you gave me a lot of info I already had but didn't actually answer my first question. It was very specific to the CREATE CREDENTIAL part of...

I used to be strongly against testing, but in recent years, I've come to change my mind. There are too many people out there who claim to be programmers/developers/DBAs,...

I was confused enough by the explanation that I had to try this myself. Two statements in the explanation are contradictory (emphasis mine):

... COUNT_BIG(all column_2) will count all rows...

Expect the exam to take the full three hours they allow. If you try to go too quickly, you're going to...

We've actually had the exact same problem with synonyms involving a linked server, and we haven't found a solution. We eventually gave up and abandoned synonyms altogether.

Ed

Ummm... no. This answer is wrong. Sorting the date in descending order will move the nulls to the bottom, but it will not leave the rest of the...

This question is wrong. It specifies the column "join_date" but one of the "correct" answers uses the function "month(dob)".

Ed

Nothing's more important than getting the product right, so why are they "launching" SQL2008 today? It's not actually going to be released now for nearly a year! I...

From my point of view, there is definitely room for both identities and natural keys, but I have to say that I much prefer natural keys for one main reason...

My first instinct was to say that the source code should be released publicly, but the more I thought about it, the more I found flaws in that concept. ...

Sponsored content can be extremely useful, provided that proper disclosure is in place and it's not just marketing hype. I think the approach you've outlined will work well.

One idea:...