Roy,

Apologies on behalf of the community. I have removed the comment, which was inappropriate. I did not mail the guy since I don't think it would do any good. He...

There are definitely ways around this, but the standard install, the "secure by default", IMHO misses out here. I've not worked with products that secure "administrator" from the sysadmins, and...

Gary's argument for the award (and Jack's) are the problem I've seen with the MCSE, MCDBA, etc. over the years. HAving one doesn't mean you have expertise in clustering, replication,...

It's not that I did not realize an Admin could do something like attach a debugger or copy files. It's the fact that it is so easy for an anonymous...

You can read about the exam here: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-450

Most prep materials do cost money, and you should think of this as an investment.

Just starting to investigate this command. Does the setting of "cosmic string count" on the server have any effect?

I'm with Bru and others. Set it to grow by a decent percentage (use MB) of the original size.

So for a 10GB db, I'd think about whether I expect...

That's a pretty good list. I might scan with SMS or Ops Center if you have them to see what's down.

You might build a list of SQL Servers that need...

Just saw this. Very nice and creative. Had me smiling this am.

😀

That is a good point, and I do believe that shortly you won't be able to buy SS2K8 from MS. I bet resellers will still have it for awhile, but...

I didn't see your response as nasty. Came across fine to me. I have added a note to the top and bottom of the article to check the discussion.

Actually I think this is the way to do. So many people have complained about features in SPs, myself included. I prefer SPs to be just fixes.

Adding those new features,...

http://www.sqlservercentral.com/articles/Video/63805/

Tom,

I think a lot of companies are looking at things this way. Some may even skip SQL 2008 and R2 from 2005 to jump to 2011 or 2012 since...

It's not in NA either. Our current lead isn't a SQL person, and also has some development area MVPs. I've had, I believe 4 leads, only one has been a...