A TDE enabled database would not synchronize in an AlwaysOn availability group, and ERRORLOG said please create a master key. Here is what I found.
SQL SERVER – Unable to create login AlwaysOn availability group secondary replica
Creating a login on an AlwaysOn availability group secondary replica failed with Error 3906, database is read-only. Here is why it happens and what to do.
SQL SERVER – Added New Node in Windows Cluster and AlwaysOn Availability Databases Stopped Working
A client added a new node to the Windows Cluster and their AlwaysOn databases stopped synchronizing. The culprit was a wizard default, and here is the fix.
SQL SERVER 2016 – Enhancements with AlwaysOn Availability Groups – Notes from the Field #121
In Notes from the Field #121, Mike Lawell covers the SQL Server 2016 enhancements to AlwaysOn Availability Groups and why this feature keeps getting better.
SQL SERVER – AlwaysOn Availability Group Stuck in Resolving State For Long time
Why does an AlwaysOn availability group get stuck in resolving state for a long time? Here is what that state means and where to look for the cause.
SQL SERVER – Attaching and Restoring Database in Clustering Generates An Error – Notes from the Field #115
Attaching or restoring a database on a cluster and getting an error? In Notes from the Field #115, Eduardo Castro explains what goes wrong with Clustering.
SQL SERVER – How To Improve Performance by Offloading Backups to a Secondary Replica – Notes from the Field #108
Want more from two servers? In Notes from the Field #108, Eduardo explains how offloading backups to a Secondary Replica can make the primary server faster.