I assume other backups work (for user databases)?

I'm not sure what you can do other than rebuild msdb from scratch. Or restore from a previous backup.

I'd script out jobs, alerts,...

The service account for SQL Server needs rights, not your account.

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...