To have jobs run across multiple servers, you don't need Admin access.  You need a plain vanilla domain user (not domain admin) account for the SQL Services to use and...

Another instance when a DBA may have local admin rights on a box is when the DBA is responsible for "soft" server administration support.  This has been the case in...

If you're not talking about a Database Restore, please be more specific in what you're trying to do.

Carsten,

We have a job (which I cannot post because I did not write it) which monitors our job execution times.  It tracks the average run time of each job in...

Someone else suggested Computer Associate's Erwin diagram tool.  I ditto this as it has a great feature I really enjoy using.  Once you model your database, you can reverse engineer...

Ah. Okay.  Sorry about the misinterpretation. 

At least you got it working.

Ah-ha!  That actually makes sense.  And explains why it keeps resetting everytime I look at it.

Thanks, Crispin.  I'm mailing out your cookie now. @=)

What's different in the OS / Server configuration between your QA environment and your Production environment.  This is probably what's causing the issue.

I'm guessing it has to do with...

This is a very interesting topic.  Even more so because this subject crosses career lines and isn't an IT Only problem.  When I was in Customer Service, I had some...

Oddly enough, my first real SQL DBA job was the toughest to get for me too.  No one wanted to hire me because I didn't have enough SQL Server experience,...

Oh, and I did mean to post a reply to one of the first questions on this thread.  As others have said, unless you have the actual MCDBA certification, you...

All,

Sorry it took so long for me to respond.  Just got back from Rhode Island yesterday.  I'm glad you all enjoyed the article.

Several people bring up some good points.  I'll definitely...

Anil,

Unfortunately, this is something that is changeable depending on what types of information you keep track of in your database and what type of business you have.

Part of our SOX...

I can hardly find anything in BOL about either NTLM or Kerberos.  What I can find seems to indicate this is a server setting, not a SQL setting.  Any thoughts...

Steve,

Unfortunately, even that practice wouldn't fly at my work place.  Everything must go through a rigorous SDLC.  We put things into Test, have the BAs test it.  We put it...