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.
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.
Introduction to Contained Availability Groups
Availability Groups have been one of the best high availability and disaster recovery options in SQL Server for a long time. They let us move a group of user databases together, keep replicas synchronized, offload some read-only workloads, and give app…
The post Introduction to Contained Availability Groups appeared first on Denny Cherry & Associates Consulting.