An interesting article for a Data Warehouse newb. I'm very much looking forward to reading the follow up articles in this series. Thanks. 🙂

At least one 😉

Nice question, took some careful thought to get the correct answer.

LOL. Already had Google try and catch me out, I expected better from SSC 😉

Thanks for the 7 points though 😎

Good question, thanks.

Good question and not too difficult. I did my certs in 2008 and so my natural inclination was to answer the question with that version in mind 😀

I'm half asleep this morning. Missed every one of the potential gotchas (implict conversion, US date format and extra comma), thought "this code looks ok" and selected the right...

Tested select * from ::fn_virtualservernodes() on both 2005 and 2008 clusters and it returned correct results for both.

Definitely a question with practical value. It's just a shame that Microsoft hiked the price up so much for R2, I can't persuade the decision makers to go for...

Had to resort to Google on this one since I didn't have a clue.

Please see Microsoft MSDN for further info.

I had this issue when using a domain local group to provide SQL Server authentication across domains (users and group were in one domain, the SQL box was in another)....

Easy two points. Thanks.

Guessed the correct answer for the right reasons. Had to read it a few times to understand what was being asked. I learned something new here. Nice question!

Nice work!! It's often said that to truly understand a concept you should be able to explain it to others in simple terms and you've definitely done that with...

I passed the...