Go with Raid 10 or 1 for everything. Avoid R5 for performance reasons.

If you can separate out the OS from SQL data/logs, do that. If you can separate out logs...

I like Lynn's approach, but you do need some type of response to the client to let them know if the update took place. Or at least logic in the...

I tend to avoid both when I can, but I also go by the advice that GSquared has given. That's a good summary of both of them.

It would be nice, but most people would scroll to the bottom, click the check box, and move on.

It comes in cycles. Lots of new people, have to teach them...

And all three of these paths are valid? Meaning that there are the subs created and the backup file is correctly named?

Have you tried restore with headeronly to verify the...

There is only one version of SQL Server 2005. It will install or upgrade as needed.

As far as pricing, I don't think there are upgrade discounts, but I could be...

Please do not cross post as we scan all forums.

Are you looking for classroom training? My company, End to End Training, offers some good options. http://www.endtoendtraining.com

The product is too big for you to get a complete lesson in the...

Johan has the right idea. The way your're executing things, you've changed context in one batch, but it goes back for the next batch (sp_executesql). You need to have things...

I never append. I've had cases where the file gets corrupted and then you lose a bunch of backups.

I always overwrite, but I use a new file name for each...

You might want to setup alerts on the log disk space used to catch it before it fills.

I wish someone would sue over this, not necessarily requiring admin rights, but not disclosing them. It would be a good way to force some disclosure.

I got told this by...

I'd add the user twice, as the parent and child, maybe including a flag if it matters who referred who.

Then if you update/delete, you can easily find all the...

It's possible you have some sizing differences or something else. Why create the blank database? You can restore the database backup to a new database and give it the correct...

I don't know of a way in T-SQL. The problem is that you'd need AD rights to check for the accounts being disabled. Plus if they're disabled, what if they're...