Yes. You can put the distribution database on whatever server you wish.

However you need to make sure it is highly available.  If you lose server 3 then your replication stops...

Or if you don’t want to do it yourself, look at DBATools and Remove-DbaAgDatabase which will do it all for you.

Please have a go and try, the more you try the better you will become.

Post the query you use and it will show initiative that you have at least tried.

It...

So you want to query the DMVs sys.availability_groups, sys.dm_hadr_database_replica_states and sys.databases.

These 3 will get you the databases per AG.

From there you can then write a loop or whatever based approach...

The old exams are no longer valid.  The MCSA/MCSE path has been retired for some years now.

Please take a look at the new DP exams, DP-300 would be the replacement...

If there is a regression in the module you should report said regression to the GitHub repository so that one of the community developers can investigate it.

Please post your issue...

The probable best way to achieve this is to run sp_blitzcache and store the results in a table periodically.

The cache will contain which statements wanted a missing index as long...

All the blitz procedures are in GitHub Scott so you don’t need to give Brent your email anymore to get them.

https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit

A differential won’t work in this scenario as you cannot do a point in time restore with a differential.

So if I understand the timeline

12:00 log backup is taken

12:30 data loss...

What is the availability mode?  Sync or Async?

As you mention resume data movement I am going to say your in Async mode so yes the secondary database should be in...

Re point 1 - that no one will be able to answer for you, it will depend on so many factors, CPU/Memory/IO/Other Activity/HADR, the best thing there would be to...

Unsure if a distributed availability group works cross domains but would be a possibility.

Then destroy the DAG at migration time and then recreate the listener on the new side as...

Use DBATools and the Set-DbaAgentJob function.

You can easily read in the text file as an array of jobs to pass to the function to enable of disable en-mass

$JobsToChange = Get-Content...

Your applications need to have connection retry logic written into them.

When a failover happens it doesn’t transfer the active sessions so you need to ensure you reopen the session after...

No far from it.

Even in Azure you need to think about your HADR options and that’s both at IaaS and PaaS offerings.

While Azure SQL Database (PaaS) will move around the...