Blog

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.