Search Suggest

SQL_DB
SQL_DB

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…