I would have to agree with Lynn. I see no problems here. If you would feel better limiting the memory for SQL I would set the max memory...

Please confirm that we're discussing AD domain login passwords for the service owners of the various SQL services. I assume so, but need confirmation before we can formulate suggestions...

This was a decent book for getting through the test. I also recommend the WROX series of books for a more-detailed source of information. Furthermore I suggest subscribing...

Many times this means "all those duties the Senior DBAs don't want to perform". If I were you I'd plan on a wide scope of work. After reviewing...

I think it speaks towards how we are as a community that we don't shoo "newbies" away with some of the various rude comments you do see on other sites....

All the previous tips seem like quite a bit of work. I find that the following code block works for my needs:

EXEC xp_logininfo 'DOMAIN\GROUP_NAME', 'members' does the trick.

Glad to hear it.

Try this:

grant execute on master.dbo.xp_sqlagent_enum_jobs to {user};

grant execute on master.dbo.xp_sqlagent_is_starting to {user};

No resolution - still open issue.

It's a shame that I'm finding out about this so late. At such short notice I'll not be able to attend, but I'll place a link out at WMSSUG.org...

Back to the licensing issues for a second. Are you using Enterprise or Standard Edition on the cluster? You may not think licensing is much of an issue...

Absolutely Pedro!

Pedro, I am writing an article on the steps to prepare for rebuilding the master database and I'd like to cite your script for the securables creation process. If...

Thank you everyone for the positive feedback!

We're right around $4.15 usg here. I don't know how our gallons compare to yours. I thought you were using litres over there. The metric system never...