Spot on! (no matter the chosen technology)

Alternatively have a look at "Get packages from SSIS Catalog"

it uses Powershell to download the packages

You should have removed...

check: "Checklist: Best practices for SQL Server on Azure VMs"

Does the service account of the target server ( 2016 ) have read authority for the backup file ?

There is something fishy with the question:

1. Are you really going to mix all Item types in this comparison?
2. How could you handle equal itemcount rows for a given country?

Spot on, Jeff !

The main point for people to prefer varchar over char is that their GUI development tool doesn't have to bother with trailing spaces.

Sorry, Steve, I clicked "report" in stead of quote 🙁

Closing a post after 1 year of no responses seems fair to me.

That is normal, as tempdb will always have the same startup size per file on a given setup and will grow as needed.

I don't think we can configure its size...

xEvents are your friend !

Have a look in the attached scripts file on how I monitor hand handle failovers ....

et voila .... they already fixed it 🙂

You can get all backup / restore history from msdb database!

have a look at ....

select  BU.server_name
      , BU.machine_name
   ...

DBATools.io has a nice function called Find-DbaDbDuplicateIndex (however it has IMHO aflaw and does not report IsUnique for an index, reporting duplicate indexes composed of...

IMHO: No

It should be set to support the workload of the instance: "Why Cost Threshold For Parallelism Shouldn’t Be Set To 5"

Someone mentioned that issue on the SQL Slack community also Johan.

Unsure if that was also yourself, but if you file a feature request on http://www.DBATools.io/issues,  someone will take a...