Curious Cases of Availability Groups
Explore curious cases of Availability Groups in this informative PASS Data Community Summit talk. Delve into common and uncommon scenarios encountered when implementing Availability Groups in production environments. Learn about readable secondaries, side effects, multiple listeners, in-memory OLTP, and nondurable tables. Discover solutions to challenges such as database migration, removing mirroring, and configuring historian mode. Gain insights on updating statistics on read-only secondaries, running old cardinality on read-only databases, and improving log transmission. Address practical concerns like firewall configuration, secondary connections, and routing. Equip yourself with valuable knowledge to tackle Availability Group implementation issues in your professional endeavors.