Contained Availability Groups

Contained Availability Group and login failed

A contained availability group is a special availability group which manages its owns logins, users, permissions, jobs… with a dedicated master and msdb system databases, more information here.At a customer place we found some unexpected “login failed” for(…)

Contained Availability Groups error

During my testing about the new SQL Server 2022 feature Contained Availability group I faced an issue during the creation of the system databases on the secondary instance. I used the wizard to create a new Contained Availability(…)

Reminder about SSMS

As you know, since SQL Server 2016, SQL Server Management Studio is not anymore part of the SQL Server ISO files and needs to be downloaded independently. If you want to have a complete list of all SSMS versions(…)

First look at SQL Server 2022 Contained Availability Groups

Introduction SQL Server 2022 introduces the new concept of Contained Availability Groups. This is something that DBAs have been waiting for since Availability Groups were introduced 10 years ago. Contained Availability Groups enhance the Availability groups by(…)