Search Suggest

SQLSERVER
SQLSERVER

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 …