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

Tag: azure sql db

Free Online Sessions – Building the €100 DWH and Indexing for Dummies

September 11, 2025September 11, 2025 Koen Verbeeck Leave a comment

I’m giving two online sessions soon on virtual events that are free to attend. The first one is at Retro Data (20th of September), a new virtual conference focusing on established technology, instead of preview features. My session Building the €100 data warehouse with the Azure Data Platform at 10AM UTC+2. The other session is […]

Read More

Book Review – SQL Query Design Patterns and Best Practices

March 5, 2023March 5, 2023 Koen Verbeeck 1 Comment

Disclaimer: The publisher – Packt – sent me a free copy of the book for the intended purpose of a review. At the time of writing, the book is yet to be released (the date is set at the 22nd of March 2023). The book SQL Query Design Patterns and Best Practices: A practical guide […]

Read More

CONCAT_WS Function Truncates Text

January 31, 2023January 31, 2023 Koen Verbeeck 2 Comments

I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very long, for example if a dimension has a lot of columns. When debugging, I noticed a couple of statements failing with various errors. Turns out, they […]

Read More

Authentication Error in Azure Devops when Deploying DACPAC

April 7, 2022April 7, 2022 Koen Verbeeck 1 Comment

I was building a CI/CD pipeline in Azure Devops, where I was building my SSDT project into a DACPAC file and then deploying it to the development server. For the deployment step, I use the built-in Azure SQL Database deployment task. I was planning on using SQL Server authentication, so I created a SQL user, […]

Read More

Feed

RSS

Social

  • Twitter
  • LinkedIn

Former MVP

Former Microsoft Data Platform MVP (2017-2025)

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

  • dataMinds Connect 2025 – Slides & Scripts
  • Cloud Data Driven User Group 2025 – Slides & Scripts
  • Retro Data 2025 – Slidedeck
  • Secure Logic Apps with OAuth Authorization
  • Free Online Sessions – Building the €100 DWH and Indexing for Dummies

Categories

  • Azure (28)
  • Azure Data Factory (27)
  • Azure Devops (5)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (61)
  • Fabric (19)
  • Power BI (42)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (114)
    • 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