News

In this post, I want to cover how you can create a dacpac for SQL Server 2022 databases using sqlpackage. So that you keep the new SQL Server 2022 compatibility level when you deploy new databases.
[!INCLUDE SQL Server ASDB, ASDBMI, ASDW]. Use contained database users to authenticate [!INCLUDEssNoVersion] and [!INCLUDEssazure-sqldb] connections at the database level.A contained database is a ...
To create a contained database user in Azure SQL Database you must connect to the database using an Azure AD identity. ... cannot already be present in the master database as a SQL Server ...