The Magic Behind ADR: My 8KB Talk
This week, I am honored to be speaking at the most excellent 8KB conference. If you aren’t aware of this conference, it’s ran by several members of the SQL Community. It is designed to be a deep dive internals conference. While it starte…
The post The Magic Behind ADR: My 8KB Talk appeared first on Denny Cherry & Associates Consulting.
SSMS Needs Improved Visual Indicators for Contained Availability Groups
As I’ve been spending more time working with Contained Availability Groups (CAGs), I’ve run into something that I think is an issue as they become more prevelant in the wild. To be honest, I do not have a lot of clients running CAG’s …
The post SSMS Needs Improved Visual Indicators for Contained Availability Groups appeared first on Denny Cherry & Associates Consulting.
Contained Availability Groups: Issues to Watch Out For
Contained availability groups solve some real operational problems, especially around logins, jobs, permissions, and supporting metadata. They can reduce drift between replicas and make failover cleaner.
That does not mean they are magic.The post Conta…
Contained Availability Groups: Jobs and Security Objects
In the first post, I introduced contained availability groups and how they bring contained versions of master and msdb along with the Availability Group. That matters because many applications depend on more than just user databases.
Two of the biggest…
The post Contained Availability Groups: Jobs and Security Objects appeared first on Denny Cherry & Associates Consulting.