Moving to SQL 2005 - strategies. Please don't post in author's forums.

Now that is interesting, didn't know what. Worth of a blog post.

DNS and DHCP servers do need to respond quickly, but they have low resource requirements, and I've seen many people virtualize these easily.

Going to a VM doesn't mean your server...

#3 looks good.

For #4, what you want to do is set up a CASE statement. Are you looking for people in each group/range in one query or are you trying...

Ah, data file, sorry, no this won't help.

My apologies for not reading closely enough. I'll blame it on a lack of sleep, which is again, my fault.

If the data file...

It's a management thing. If you run them in MSDB, they are in your backups, and when you restore on another server, they are contained. In the file system, you...

Barry, interesting point. What if you can't "attend" unless you get the freebie?

I guess you will have to decline in that case to avoid the legal issues.

Sorry, poor choice of words. No danger, no issues with integrity.

It works by building lots of small transactions to fill the VLF inside the log, then trying to shrink. Since...

Finally!

I added this to the shortcut list on the left as well.

That's very strange. No system DSN set up in control panel?

Is this NTAuth or SQL? I'm assuming NTAuth. If you log in, and try to connect, do you see a...

this should strike-out strikethrough

Ravi,

We do make articles in books a few times a year available for download, but it takes time and resources to reformat them. Also, if we make Word/PDF versions available,...

Good point, I'll add a couple IF items now. Well, as soon as I figure out how to use Google to find the tags 😉

Always start with Books Online. They always have the basics in there. After that, there are some good whitepapers on Log Shipping and mirroring on MSDN

http://msdn.microsoft.com/en-us/library/cc917681.aspx

OK, walking a line here. I know a lot of people in PASS, especially the Board, so I hear things that I'm not sure should be public. So, I can't...