Check actual replica
You want to execute script against database only if actual database is primary replica? Sometimes you need to continue execution of batch only when actual database is primary replica on...
Suspend & resume data movement
Sometimes you need to reinitialize data movement in Availability Group. You can do that by right clicking Availability Database in SSMS then clicking "Suspend Data Movement" then clicking "Resume Data...
Backup locations
Returns list of backups created over all databases, with location, timings and size information. This script is useful when you want to quickly check where your database backups are stored,...
Connectivity issues
Return actual state of local replica connectivity to other replicas in Availability Group. Can be useful for fast check or in some automation or inventory solution....