Skip to content

Contained Availability Groups in SQL Server 2022

Photo of Ronen Ariely
Hosted By
Ronen A.
Contained Availability Groups in SQL Server 2022

Details

The Data Platforms GlobalHebrew user group is pleased invite you to the second session about new features in SQL Server 2022.

About the upcoming meeting
While being an awesome feature introduced in SQL Server 2012, Availability Groups were always missing the ability to synchronize server-level objects between replicas. This finally changed 10 years later, in SQL Server 2022, with the introduction of “Contained Availability Groups”.
A contained availability group is an Always On availability group that supports:

  • managing metadata objects (users, logins, permissions, SQL Agent jobs etc.) at the availability group level in addition to the instance level.
  • specialized contained system databases within the availability group.

In this session, you will:

  • learn about the similarities, differences, and functionalities of contained availability groups.
  • see a live demo of the creation and usage of a contained availability group.
  • learn how to work with contained availability groups and its pros and cons.

About the speaker
Eitan Blumin is a Microsoft Data Platform MVP with decades of experience in all fields relating to Microsoft SQL Server databases and the Microsoft Data Platform.
Eitan Blumin is currently working as a Senior SQL Server Consultant, Solutions Architect, and DBA Team Leader at Madeira Data Solutions, the leading Microsoft Data Platform consulting company in Israel. Other than his day-to-day consultant work, he also co-hosts the popular "SQL Server Radio" podcast with Guy Glantser, writes professional materials for the SQL Server community, delivers professional presentations and courses, and serves as a pivotal source of expert knowledge for the Madeira team.

Register to the community DL:
Note! Registration for the event does not register you to the community. Information about the upcoming meetings, links to download presentations and watch meeting's recordings after the meetings and administrative information is sent to registered community members. If you are not registered (or if you are not sure you are registered) for the Data Platforms GlobalHebrew community, then please fill out this form: https://forms.office.com/r/V2erSwdgdc

Photo of Data Platforms GlobalHebrew group
Data Platforms GlobalHebrew
See more events