Creating a Distributed AG can have some issues. This article covers the problems that we encountered.
Availability Groups
Duplicating an AG to another environment, for migration purposes.
Overview For a future article, I require a Listener for the Availability Group (AG) that was created from this article. This post describes the simple steps required to create a Listener.
Background For some investigative work that I had to do, I required an Availability Group (AG) that I could destroy and rebuild without impacting anybody else. Hyper-V was an obvious solution and this article describes the steps required.
Background Whilst reading up on the finer details of High Availability Groups (HA Groups) I have discovered that it can, under certain circumstances, use Snapshot Isolation Level and therefore, row versioning. This has implications with your monitoring and maintenance tasks.
Background Because one of the nodes in our AG was having Windows updates applied, it was necessary to suspend data movements for all databases involved in the AG, on that server. Upon my return (after the maintenance was completed) I was unable to connect to the server, with a message that didn’t really match the …
Notes on SQL 