On this session I will show the audience how to create a Visual Studio Database Project (DACPAC), import into it a schema from an existing database and define an environment-scope security configuration using pre-deployment scripts to securely provision users using both Azure Entra ID and SQL Authentication methods, lastly, I will show how to deploy the database via DevOps YAML pipelines targeting different environments.