Mattias De Smet

Jan 30 2023

Business Intelligence

PowerBI : Manage dataset access requests

by mattias

No Comments

When a PowerBI report gets more and more popular, all kind of users start requesting access to a report. Your PowerBI developers made the dataset, setup Row Level Security, and...

bi, dataset, PowerBI, security

Aug 28 2022

Business Intelligence

SQL : split delimited field in columns

by mattias

No Comments

These days of PowerQuery, Spark and other query tools there are quite a range of options available to split delimited fields, but what if you have a table in your...

0NF, database, db, delimited, json, normalisation, sql, SQLServer

Aug 27 2022

Business Intelligence

SQL : CLR to do base36 decoding

by mattias

No Comments

Always wanted to escape the set based world of SQL and get back to that good old .Net procedural (even object oriented) experience for a quick calculation? Let me show...

assembly, database, datawarehouse, db, etl, sql, SQLServer, tsql

Aug 22 2022

Azure

Azure : Cheap static webserver

by mattias

No Comments

A small nifty feature in Azure storage accounts allows you to use them as a web server for static pages. Much cheaper alternative than setting up an Azure VM with...

azure, static, storage, storage account, web, website

Aug 21 2022

Azure

SQL : Move tempdb to D:

by mattias

No Comments

When you install SQLServer on an Azure virtual machine, you can take advantage of the D: drive that comes with such a VM. Its characteristics are that it is local,...

azure, database, datawarehouse, db, dba, sql, SQLServer, tempdb, vm