I know that we can use ApplicationIntent=ReadOnly to connect to the secondary read-only nodes in an AG setup. Is it possible in some way to tell the DNS server which node is which on failover so we can just point an alias to the read-only node and not have to use a different connection string? I realize this might take some handling in events or something similar, but it seems like this would be useful to give people an alias to use for reads.
I realize that it wouldn't be correct 100% of the time, especially right after a failover, but wondering if this is possible in some way.
