It's hot linked, but it's Back Office Administrator from Hell: http://www.theregister.co.uk/odds/bofh/

Your ed is coming soon. Haven't had time to go over the podcast, but I'll get it sorted and out next week.

It does seem to be tough pulling information out of people today. The "ideal SQL Server" thread has me slightly frustrated.

Gregory,

How about if we ask is there an existing system? Taking guesses on new servers without any history is hard. Any ideas on how much data/activity this system will see...

You want lots of memory, enough CPU for your system load, and a few separate physical disks. These can be DASD or SAN, but you want to have data separate...

MANU-J. (5/3/2010)

---

Renuka,

As per http://msdn.microsoft.com/en-us/library/ms179344(SQL.90).aspx

The loss of a partner has the following effect:

3. If the only mirror server becomes unavailable, the principal and witness continue.

Hope this answer your...

Why isn't Asset2 linked to MasterAsset1 in the result? What you've posted doesn't make sense.

Third vote for Express. If you go with SQL 2008 R2, you have an increased 10GB size limit.

You also have workgroup to go to if you are watching costs.

Editions...

For backups, typically you would write a script or use a maintenance plan for the backup and schedule that as a job. Here are a few resources for that:

http://www.sqlservercentral.com/articles/1535/

http://www.sqlservercentral.com/articles/1353/

Note that...

Lots of scripts here for you: http://www.sqlservercentral.com/Search/?q=backup+log&t=s

Yep, it's an old salt mine and sounds cool. However, not being an underground guy, if they offer a tour, I'll send you, Brandie. I don't even go into mines...

Worst practices can definitely be a better starting point somehow. At least you can point to something that they can see is a bad example.

David,

You are correct. I think it's much harder to lead, and since the bar is set so low for managers, they tend to follow that path.

0-4 this week. Popout, fly out, FC, K. Not so good today on a chilly, rainy day in May.

I've seen a couple incidents of plagiarism lately on different sites. Not all from this site, but a few places that have copied info from MSDN/Technet, or other blogs.

It's a...