Databases in DevOps - Publishing profile Case I can’t release my database project due an error “data loss could occur” error code Updating database (Failed) *** Could not deploy package. War…
Schedule Up/Downscale Azure SQL Database (API) Case I want to up- and downscale my Azure SQL Database within my ADF pipeline. You recently showed how do this with Powershell code in an Automatio…
Schedule Up/Downscale Azure SQL Database (TSQL) Case You recently showed how to up- or downscale my Azure SQL Database with Powershell code in an Automation Runbook, but is there a way to do this …
Schedule Up/Downscale Azure SQL Database (Az) Case To save some money on my Azure bill, I want to downscale the vCore or the number of DTUs for my Azure SQL Databases when we don't need a hig…
Databases in DevOps - Build Pipeline Case Before we can deploy our database project through the DTAP environment we need to build it to check whether the merged code of all developers st…
Databases in DevOps - Pre-Deployment scripts Case I'm using database projects combined with Azure DevOps CI CD and I want to deploy data through my DTAP enviroment for some reference tables.…
Databases in DevOps - Introduction Case I want my Data Warehouse databases in Azure DevOps just like my ETL projects and use Contunious Integration (CI) and Continuous Deliver (CD) for…
Azure SQL Database vs Azure SQL Data Warehouse Case As we slowly move from on-premises data warehouses with Microsoft SQL Server to cloud data warehouses in Microsoft Azure, we need to know more a…