Mattias De Smet

Dec 27 2024

Get notified when Azure secrets are about to expire

by mattias

No Comments

Using Azure EntraID App Registrations is almost essential for any type of application security or person-independant access to APIs and other autorization flows. Always follow the best practices when setting...

Dec 20 2024

Uncategorized

Datalake support in SSIS

by mattias

No Comments

While new data modern data warehouse projects are often started with cloud based ETL products like Azure Data Factory, Synapse or Fabric pipelines, many companies still have a large investment...

Nov 05 2024

Business Intelligence

Orchestrate Fabric Data workloads with Airflow

by mattias

2 Comments

With so many different Fabric items to work with that allow you to move and transform data, it becomes essential to have a way to “arrange” all that movement of...

Aug 27 2024

Business Intelligence, Technology

PowerBI : refresh a PowerBI semantic model from a SQLAgent job step

by mattias

No Comments

The data warehouse technologies and architectures are changing at ever faster pace. Many organisations still have a large investment in a full SQLServer stack to load their data warehouse, but...

Aug 20 2024

Business Intelligence, Technology

PowerBI : treating fields containing HTML tags

by mattias

No Comments

Some source systems tend to store HTML code in their back-end database, so they can more easily render it in the web UI, and allow the end-user to provide some...