I don't believe this will work either. You might be able to script out jobs/alerts/etc. and re-run the scripts, but I doubt a restore will go since it will likely...

I get bored or can't focus at times and one thing I've learned is that if you can't work (and it happens), don't work. Don't worry about it, take care...

RAID 0, for production, including production workstation, is a bad idea. It's a huge gamble that's not worth it.

Raid 5 is better for protection, R1 or R10 even better.

I just...

I agree that commas at the beginning aren't natural. It took me awhile to get used to it, but after years of comma ending, I found comma beginning much easier...

Local Service is recommended for local services that do not need to access the network. It provides limited rights. Local system is similar to the administrative account (local) and has...

Thanks, I'll pass along.

Management buy-in is key, otherwise you'll have trouble enforcing any standards.

Thanks!

I have 2 USB MyBooks from WD. Both 500GB and they work well, though it seems they don't like being on full-time. I now use them once a week or...

I think you need a combination of solutions, and nuclear is part of it. The layman's view of nuclear is tremendous danger and waste. That isn't quite true. There's some...

SQL Server used to run on other processors, but I'm not sure there was a great advantage.

If it ran on Linux, then there are definitely other places it might be...

I use the dkranch-manure-spreading-formatting-finger machine. 😉

I am supposed to learn SQL Refactor and some other tools, but to date I've never used a code formatting tool. Years ago I tried...

I'm not sure this script captures everything. don't forget you have a fillfactor, so pages are not completely full. I haven't checked your calculations, but that seems like a very...

T-SQL cannot do this . You will need some sort of scripting to handle the transfer. You might be able to kick off the transfer with xp_cmdshell, but you are...

A bit late, but be sure you research the issues from SP2, especially with maintenance plans. You might want to prep CU2 or 3 as well.