Mattias De Smet

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

Aug 20 2022

Azure

Azure : Connect to Azure SQL database

by mattias

No Comments

Setting up an Azure SQL database is easy and fast, but you might bump into some problems connecting to it. I’ll share a couple of tools that you can use,...

azure, connection, database, db, errors, firewall, sql, SQLServer