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…
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 Snack - AAS and On-Premise Data Case You are building a Tabular model in combination with Azure Analysis Server (AAS) and you want to use an on-premise SQL database as source, but y…
Loading tables by using BIML and meta architecture Case How can we simplify the process of loading database tables and reduce the time needed to create SSIS packages. Solution There are several steps …