If you restore master, you get logins, linked servers, config settings (These need to be checked if different hardware).
If you restore msdb , you get jobs, operators, schedules, all...

Send the mails locally with the local client first. Make sure that your SMTP sender can do so.

You can do this with telnet or a local client :

Hmmm, I have no idea. It looks like there is some issue with the service for sure, which I'd guess is the upgrade. The note about the cert being about...

What's the exact error?

Also, I'm guessing that from what you said the SSRS service won't start? Or is the site won't load?

I got this from someone: https://twitter.com/EduardoDBA/status/1034104956939321344

Just open the old SSRS Configuation manager and backup the certificates, then restore it on the new ssrs version

In case you don't see it, Steve added a decimal to 100.

I do that as 100.0, so the decimal is not missed.

Shouldn't the knight be in front of the monitors, to defend them?

My guess is 1. There is likely some large customer that wanted either their really poor OLTP system to handle 200+ keys, or there's a DW that needs this and...

Correct. You could have set up log shipping with a backup and never had a backup taken, so log shipping would not work. If log shipping is working, those are...

What's the use here? How often are things updated? Certainly you have duplicate data in that there are a large percentage of M and F in there, so you could...

If you look closely, it does do a count, but it qualifies the count in a way that results in scanning every row.

Keep in mind as well that despite any ordering in the clustered index, you might not get rows back in that order. If there is parallelism or the engine finds...

Apologies, I dont' have time to dig in, but this might help: http://www.sqlservercentral.com/articles/Dynamic+SQL/131473/