Enjoy, you two. Can't make this one.

Noticed that. Logged a bug

It won't work. The SQL Server instance will have the Windows host name (outside of a cluster), even with a named instance. Rules of Windows hosts mean no two duplicate...

Keith Tate (4/23/2014)

---

Taking the questions/scenarios out of the context of the lab environment (strange environment, limited time, no internet just BOL) would detract from the experience that most of us...

Yes

andrew gothard (4/23/2014)

---

jasona.work (4/23/2014)

---

Gary, I think if MS open-sourced the MCM questions and scenarios, you'd fairly quickly find people using them as templates to create new questions and scenarios for...

What's the cost? What do you see as a downside?

A little lawyer...

Yes and no. As a DBA, I've tried to be proactive and look for ways to prevent issues....

http://www.sqlservercentral.com/search/?q=script+out+permissions&t=s&sort=relevance

Thank you. I'll be back - http://www.youtube.com/watch?v=WgPePk3kGZk

sp_addserver should populate the fields correctly for applications to work with the instance. I'm not surprised it isn't documented, but you can certainly submit a doc bug to have that...

Sounds good. It's yours.

Both are fine. Include some scenarios/examples, so that someone not sure how to do this understands what they are doing here.

Take it. I prefer that you get one done before doing another, but since this and the server one are very similar, do them both.

You can use the same style/template/language...

It's yours.