Azure SQL Datawarehouse “Gen 2”: a mayor game changer

The Azure SQL Datawarehouse is a fast, flexible, and secure cloud data warehouse tuned for running complex queries fast and across petabytes of data. The Azure DWH is build using parallel data warehouse technology which was already the pinnacle of SQL Server DWH workloads.

Adding Flemish Seasonality to your dataset in SQL

One of the most challenging tasks in data mining or machine learning is how to get seasonality into the mix. Therefore I created a construct that can insert the seasonality for the Flemish part of Belgium in SQL. With some minor alterations, this can easily be adapted for the Brussels or Walloon regions.