Blog

13 Dec 2018 When the SQL Server Agent overrides default behavior: QUOTED_IDENTIFIER

For a customer, I recently migrated one of their databases from 2012 to 2017, whilst putting compression on all the indexes. The process of recreating the Indexes on 8 new filegroups took 3 hours for a 400GB database.

11 Dec 2018 How to import a JSON-file into a SQL Server table?

Many of you are, hopefully, starting up projects to upgrade your current SQL Server to the shiny SQL Server 2017. One of the first things to do is run the Database Migration Assistant (DMA). I'll show you how to export the report as a .JSON-file.

07 Dec 2018 A Historically correct approach on the evolution of the Microsoft Data Platform

As we are nearing the end of a very interesting year, I was mesmerizing about the changes we saw this year. This took me back to what I’d later would call the very beginning of what would become my personal IT-Career, ...

04 Dec 2018 Creating and managing Audits in SQL Server

In this blog I will be talking about Creating and Managing Audits in SQL Server. We will first look at what SQL Server audit is and why you should use it. Then I'll discuss the configuration and activatation of the SQL server audit, and many more...

30 Nov 2018 When an Azure runbook does not recognize your cmdlets…

Automating a Data Factory pipeline using a runbook seemed like an easy last step in a Azure DWH setup I developed lately. The part in my script responsible to start and stop the DWH ran without problems, but then ...

28 Nov 2018 How to Automatically add measures to Power BI

Some time ago I wrote a blogpost to retrieve all the measures from your tabular cube or from your open Power BI files. I made a simple addition to this blog, enjoy! And don't forget to watch the how-to video.

26 Nov 2018 The Chamber of SQL Part 3

"Basically", Stephanie started, "we have 2 different options under the umbrella what we call Always On. We have on one side Always On High Availability Groups and on the other side we have Always On Failover Cluster Instances. Hence the confusion."

21 Nov 2018 Connecting to an (Azure) database from within Databricks

I made a very useful ELT program in python and wanted it do run inside a Databricks cluster. Databricks on Azure fully supports python 3, so I thought I was up for a walk in the park. Trying to import the database connection classes, already gave a small hint of the troubles ahead...

20 Nov 2018 OPINION – Is SSRS on Azure happening?

Is SSRS on Azure happening? Well as always in Azure it depends… If you mean that ‘SQL Service Reporting Services’ is going to be provided on Azure, the answer is NO as SSRS is a product name as well as a part of SQL Server. But...

07 Nov 2018 How To: Azure SQL DB Cross database queries using synonyms

When helping a fellow dba on dba.stackexchange.com, I came across an interesting subject. What about synonyms in Azure SQL DB? We know that synonyms that stay in the current database scope work, but how do we get cross db synonyms to work?

06 Nov 2018 Make your own SQL Server Docker Container

Recently I needed to have a SQL Server 2008 R2 instance to do some testing. I had to install it on my laptop, but I wasn't a big fan of installing such an old version locally. But I found a solution!

03 Oct 2018 Using CTAS to efficiently load large tables

An Azure data warehouse is a real powerhouse. Personally, I consider it to be one of the most performant components that can be used and build into the Lambda architecture. Ludicrous power comes with a drawback of course and that drawback is potential inefficiency.

03 Sep 2018 Waarom werken bij Kohera?

Een passie voor alles wat IT-gerelateerd is en de goesting om continu bij te leren. Twee eigenschappen die Dirk Deckers en Philippe Van Rillaer kenmerken. Lees hier het relaas van hun eerste werkjaar als Koheriaan.

07 Aug 2018 Azure pt.3: Parameterize and trigger

In previous blogposts we have been creating the Linked Services in Azure and CTAS’ing files from Azure Data Lake into tables on Azure DWH.  I finished my previous post by advising you to use Azure Data Factory V2 (ADF) as an orchestration tool for your ELT load. This is exactly what we’ll be doing in this post. 

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.