Much thanks for the tutorial, great job

Bah! If I had any control I'd give you an extra point for being a pro-active DBA

Thank you for the feedback. If I wrote the question again I would focus a bit more on learning SERVERPROPERTY options rather than nuisances of patching levels....

question is old, but taught me something new. thanks

Thanks for the share. Might especially be good for people/companies that don't have budget for 3rd-party platform polling applications. Could loop list of servers\instances + have...

Yes, very good question

Good question. Although "not need to do anything" is not totally correct. There is some initial configuration that needs to take place. Once it's up...

By default, the DAC only listens on the loop-back IP address (127.0.0.1), port 1434. If TCP port 1434 is not available, a TCP port is dynamically assigned when the Database...

Thanks for the feedback Tom. Definitely planning on writing more as it forces me to keep learning new stuff.

Thanks Nakul, that's a good one too I didn't see before. link has been included up top

I agree, good documentation on this prior to 2012 is limited. There is some good information in this book https://books.google.com/books?id=HvD2-aqsDtAC&pg=PA442&lpg=PA442&dq=sql+server+buf+array&source=bl&ots=POqF2EmvRg&sig=kJM2ygTBRcTSaNq3NzyZ2Q7eBMY&hl=en&sa=X&ved=0ahUKEwjru8G0grfOAhVP-mMKHW1bATMQ6AEIHjAA#v=onepage&q=sql%20server%20buf%20array&f=false

Under "BUF Array" and "Flushing and Freeing...

Thanks for the positive feedback! My hope was to not make the question too tough, trigger learning more than challenge. But looking at the % correct feel...

I understand what the author was trying to achieve in the question but it is still syntactically incorrect and will generate an error. (SET ANSI_NULLS = ON)

old question but still really neat

Yes, question has 2 correct answers. With option 1 being most correct.