I tend to agree that it is usually not good to manage a team that you were once part of. It creates a strange dynamic where your subordinates might not...

This article, while not from MSDN, gets right to the answer and provides a good starting point.

http://www.darkreading.com/blog/archives/2009/11/cell_level_encr.html?print=true

Nice QOTD. I didn't even know that you could set up this scripting view or that you could view the script by selecting generate change script. Good to know!

band-aid fixes. Basically our code has broken due to poor design but instead of actually fixing it through architecture changes, we like to put band-aids on it and send it...

rjv_rnjn (5/6/2010)

---

I re-read the MSDN article as to why I thought it's physical order of arrangement.

MSDN: http://msdn.microsoft.com/en-us/library/aa933131(SQL.80).aspx

Because the clustered index dictates the physical storage order of the data in the...

I think "stay interviews" are a good idea. At my company we have quarterly online anonymous surveys that go out to each employee asking how we feel about the company....

A nice research question. I got it right because of Google.

If I had not looked it up, I would have guessed a much earlier date. Initially I figured that...

Oops, I glossed over that before. Thanks Hugo!

Nice QOD! Does anyone have a link to a view that uses a CTE in its definition? I had never even considered doing this and would like to see an...

I think the answer might have been pulled from here:

http://databases.about.com/cs/sql/a/aa042803a.htm

I had to look this one up before answering because I had a feeling that I would get it wrong. My...

Ding, ding, ding...we have a winner! I feel the same way about Microsoft conferences. I went to the PDC back in 2003 or 2004 in L.A. and it was one...

I had to look this one up because the ReportService2006 answer option seemed incorrect to me. I chose the "correct" answer but only because I figured there was a typo....

I too did some part-time office cleaning, but for a car dealership. It was easy and a nice way to make some money with little to no stress. You can...

Thanks for the explanation! Makes more sense now.

Not to be too picky but if cell level encryption was available since SQLServer 7 wouldn't SQLServer 7 have been the correct answer? Even if it was undocumented and poorly...