Blog

06 Aug 2018 Azure pt.2: The story continues… Enter Polybase

Enter Polybase External Tables.  A technology introduced in SQL Server Parallel Datawarehouse (PDW) around 2013 and became more generally available since SQL 2016, allowing you to read flat files as easy as if they were database tables. 

04 Aug 2018 Azure pt.1: A word on Linked Services in Azure

How to best describe Azure Data Factory (ADF) V2?  A friend of mine described it as the ETL of the skies.  And since I based almost my entire career on ETL tools, this sounded like music to my ears. After running a nice project in ADF I can now look back on this statement, and conclude there is some truth behind it.

02 Aug 2018 Tackle parameter sniffing in SQL Server 2017 and Azure SQL Database

SQL Server 2017 and Azure SQL Database introduced a whole new set of query improvements regarding performance. These modifications are all part of the so called “adaptive query processing feature family”, which includes three major changes. I'll focus on the batch mode adaptive joins.

27 Jun 2018 World Cup Russia: Discover our Power BI dashboard yourself

You may have seen it pop up throughout our blogs and webinars in the past few months: the World Cup 2018 in Russia! Philippe Van Rillaer and I created a dashboard in Power BI about the historical results of previous World Cups, as well as results of the qualifiers for this year’s World Cup, the current teams that qualified, etc.

26 Jun 2018 SQLGrillen 2018: verslag van een topevent op hoog niveau

Op 22 juni zakte een delegatie van veertien Koherianen af naar het Duitse Lingen om het SQLGrillen 2018-event bij te wonen. Collega Ludo Bernaerts was ook van de partij. Lees zijn verslag van een dagje vol databases, bratwurst en bier.

26 Jun 2018 SQLGrillen 2018: “Fun for the whole SQL family”

On June 22 a delegation of fourteen Koherians went to Lingen in Germany to attend the event SQLGrillen 2018. Colleague Randi Vertongen joined the club. Read his report of a day full of databases, bratwurst and beer.

29 May 2018 Azure hybrid solutions with on-premise SSRS Server

For the moment, SSRS (SQL server reporting services) is currently not an Azure component. Will it be available in the near future…? I don’t know. SSRS- functionalities become available in other dashboards and reporting tools like Power BI. Today, you’ll need to work with an on-premise installed SSRS server or you'll have to setup one in an Azure VM.

15 May 2018 Store documents in Azure Blob storage using SQL

One little step in a migration track from on-premise to Azure is related to binary files like images, pdf and others. These files are often stored on many different places. When these files are stored in SQL, you probably have already created a variety of SQL procedures. But you can also use Azure blob-storage.

13 May 2018 Using Azure Blob storage in SSRS reports

Attractive reports are not only showing the hard material statistics and numbers. Visualization of your data leads more and more to graphical decision making. One particular part of your reports are images for logo’s, product images etc. When moving to the cloud, where do we need to store and find our data and images?

11 May 2018 Hybrid cloud solutions

I truly believe in the azure environment. The possibilities are huge and growing every day. Do we all need to migrate to the cloud ‘sito-presto’…yes, I think so. Why I’m so sure about this, is easy to explain. The most important reasons for me are: cost-efficient architecture possibilities and lower maintenance due to very stable architecture solutions.

09 May 2018 How-To create an ultra-fast, concurrent DataMart for Self-service reports on Azure DWH and Azure DB

With Analysis Services, you can mashup and combine data from multiple data sources, define metrics, and secure your data in a single, trusted semantic data model. The data model provides an easier and faster way for your users to browse massive amounts of data with client applications.

07 May 2018 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.

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

Moving Azure SQL Datawarehouse to the cloud made it available for the majority of all companies, enabling them to use this workhorse as a powerful engine to drive their analytical needs. Now the "Gen 2" is five times faster than the already blazing fast Gen1.

19 Apr 2018 World Cup Russia: Calculating the travel distance with spatial data

As I start to learn more about SQL, I came across a subject that was new to me: spatial data. I was curious on how it worked so I thought it might be a good idea to calculate a real life example. In this case: how many kilometers must the Belgium football team travel to play their matches?

26 Mar 2018 Security features in SQL Server 2017

SQL Server has many features that support creating secure database applications. In this blogpost I’ll guide you through the latest security features in SQL Server 2017: Common Language Runtime (CLR), dynamic data masking, row level security and always encrypted.

12 Mar 2018 Clusterless Availability Groups

SQL Server 2017 came with a couple of enhancements regarding Always On Availability Groups. The most radical change came with the introduction of “Read-scale availability groups” or the support for Availability Groups without an underlying cluster.

02 Mar 2018 World Cup Russia dashboard in Power BI: importing the teams from multiple web pages

While working on our World Cup dashboard my colleague Philippe Van Rillaer and I wanted to import data from tables spread out over multiple Wikipedia pages. With Power BI of course...

21 Feb 2018 There’s always an insight with Power BI: CONCATENATEX

Not so long ago, I was working with a client who had a specific Power BI request. They wanted to do a lookup of a column in another table, but if there were multiple hits, they wanted to display all the matching rows in the same cell. I came with a solution using ConcentrateX.