All good replies above.  I have never heard of subqueries referred to as dynamic queries.

Thoughtful posts like this make me love this site.  Thanks, Steve.

You're right...changing connection strings is another story.  But you should be able to have the AG ready for that during business hrs, whenever you want, with no impact.  I can't...

JimKern - thanks for posting all the follow-up after answering your own question.  good stuff.

Are we able to add this database to an AG during business hours?  YES.  Definitely.

Is there a performance difference between Synchronous and Async?  YES.  Many people claim it is not...

We get these msgs on an AG where the sector sizes ("Bytes Per Physical Sector") are indeed different between datacenters.  No easy solution, so we live with it.  I have...

Great post!

The listener is just a name/address, has nothing to do with voting.  Otherwise I think you're on the right track.

I'm not sure if this is best practice, but when we...

What Michael L John said.  We've been doing this since 2012, works well.

We have implemented AGs between two 2-node FCIs, as well as between a 2-node FCI and a standalone instance.  No real problems.  We generally like it.

I don't think there is...

I see.  Maybe I'll grow into it, will give it a few weeks.  Probably should have waited before posting.   Maybe just put off by the white space?  It feels mobile-ish. ...

In failover cluster mgr right click on the AG resource, properties, dependencies, and ensure AG resource is dependent on your listener.  If not you can add that dependency here.  If...

Excellent article, thank you!

re: the missing listener. It's possible that apps are accessing DBs in the 5th AG by connecting to one of the other listeners.  This will work fine until the 5th...

What do you see if you run this in both dbs?  I'm not optimistic, not even sure this will run w/out you fixing it first.  But maybe you'll see...