Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Category: Azure Devops

Database Build Error – Incorrect syntax near DISTINCT

June 24, 2024June 24, 2024 Koen Verbeeck Leave a comment

I wrote a piece of SQL that had some new T-SQL syntax in it: IS DISTINCT FROM. This predicate checks if two expressions are equal taking NULL into account. I successfully ran the code on an Azure SQL Database. However, when I tried to deploy the code using an Azure Devops pipeline, it returned the […]

Read More

How to Deploy an Azure Function with PowerShell using Azure Devops

April 27, 2022April 27, 2022 Koen Verbeeck Leave a comment

In the blog post Azure Function with PowerShell and the Power BI REST API I explained how you could create an Azure Function using the PowerShell scripting language. This Function connected with the Power BI REST API and retrieved the last refresh status of a dataset. Developing the Function is one thing, deploying it is […]

Read More

How to Deploy Azure Logic Apps with ARM and Azure Devops

April 21, 2022April 21, 2022 Koen Verbeeck Leave a comment

It’s easy to duplicate an Azure Logic App in a resource group, but unfortunately you cannot duplicate a Logic App between environments (you might try to copy paste the JSON though). So unless you want to hand craft every Logic App yourself on each of your environments, you need a way to automatically deploy your […]

Read More

Error – Reference to external ‘master.dacpac’ could not be resolved when deploying dacpac in Azure Devops

April 16, 2022April 16, 2022 Koen Verbeeck Leave a comment

I have a database project in Visual Studio. Inside the database, I use a couple of system views to fetch some metadata about tables. To make the project build successfully, you need to add a reference to the master database in the project. I created a build pipeline in Azure Devops, which builds the Visual […]

Read More

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Free Webinar – Build a data warehouse on Azure Data Platform for $150
  • Techorama 2025 – Slides
  • Redgate SQL Prompt in SSMS 21
  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest

Categories

  • Azure (26)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (57)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (113)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress