I'd say there's not a single correct answer for everyone on this question, but I'll put out my two cents.

Yes.

I see three general tracks through work life (VERY broad generalizations...

Backup and restore is out. It simply doesn't work. The Azure systems are constantly being upgraded and backups from there generally can't be restored down to on-premises. It's similar to...

Potentially. If they're holding locks, even shared locks, anywhere, you could see contention because of it. However, I suspect you would have seen it by now.

Main concern would really only...

Nope. Sounds like the application, or applications, has a problem. Time to dig into the code & configurations there.

SQL Server is a greedy cuss. Running SSIS and SSAS on the same server is going to cause quite a bit of contention.

Sounds like the transactions are closing and then opening again.

If the question is, how to run a bunch of scripts at once, I'd suggest taking a look at Powershell threading. It's a pretty easy way to launch a...

According to the documentation I'm familiar with, pure SQL Server replication is only supported with AWS RDS as a Subscriber. It's a mechanism to get you into AWS RDS. However,...

It's right in the Microsoft documentation. You can do that. I'm not sure you should (data movement out of Azure has some cost overhead), but you can.

Yes. Azure Managed Instance works in a very similar way. You can simply restore a database there. Although, you should know, that you can't take a backup from there and...

Okay, this is VERY weird. My last post, when I hit submit, errored out with "Are you sure you want to do that?"

And when I hit submit again, it...

I've always been concerned but, as I get older, I seriously worry about the medical world and hospitals and the people in them when I see things like the...

And, on top of what Steve says, 2012 is on the way out in terms of support from Microsoft. You're going to be much better served learning from much more...

The key here is to take advantage of the fact that you can store your data in the way that is most advantageous to the majority of queries. If the...

The keys should be unique. There's not a single product key for everyone. Sounds like maybe that vendor is less than completely above board.