You can shrink manually, but it's not recommended. And if you're having to shrink the log files often, you don't have enough disk space and/or you have really terrible queries...

Look in BOL for "OpenXML" (use the Index feature). This will give you a lot more information than just a post.

SQL Server requires you to prep a "memory space"...

You should do regular database size checkups to see how often and how much your database grows on a weekly & monthly basis. Then configure your max database size (presuming...

Try dumping their DNS cache and see if that works. It might be that these servers have a specific DNS name that hasn't (for whatever reason) been refreshed on those...

Adrian & Steve,

I would love your help. :w00t:

I'm in no rush, so take your time. And you can do as many or as few of my articles as you...

Congratulations!

The first step is always the hardest. @=)

I prefer Transcendor myself. Plus Microsoft's website for certification usually has a 10 question "sample" you can look at.

If you get more cert study books, aside from the training...

Hmm. Interesting. But it sounds awfully bulky and hard to maintain to me.

There's no way I would want to implement something that "complicated" in my environment. We'd constantly be forgetting...

NP. Glad I could be of help.

Sensitive information should NEVER be included in a configuration if you can avoid it. If you can't avoid it, don't use XML or any other feature that leaves the password...

Pretty similar, yes. @=)

Okay, I see what you're saying now.

Sorry about the dizoid moment. Thanks for your help!

Riga,

In every and any instance, the correct answer is "It Depends". @=)

Which configuration file is easier for you depends on how your environment is set up.

For my workplace, our...

Thanks for the link, Peter.

I just noticed something interesting and annoying.

When I add the system db roles to JobOperator, it makes JobOperator the owner of those schemas. When I go into Schemas and change...