Blog

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.

06 Feb 2018 Azure Data Architectures: Lambda

Are you familiar with the lambda architecture? It actually splits data flows into two components, receiving data centrally and doing as little as possible processing before copying and splitting the data stream into two streams, namely the real time and batch layers.

16 Jan 2018 Efficient and clear-cut monitoring of your databases with SQL Operations Studio

A while ago, Microsoft released a preview version of SQL Operations Studio. We've tested the preview version to get acquainted with it.

08 Jan 2018 Cortana Intelligence in a nutshell – Part 2

In October 2017 at the dataMinds conference (former SQL User Days) I gave a presentation about Data Lake Analytics. One of my slides contained the following topic: Fight of the Big Data Stores. Quite a nice topic to write something about.

06 Dec 2017 Latest Power BI update: share your portal with guest users

Power BI's mission is crystal clear: extract crucial intelligence from data so companies can use it to grow or strengthen their business. The latest update to the software further amplifies this creed.

01 Dec 2017 Stem op Sam als Plato-ambassadeur 2018

PLATO is het netwerk voor ondernemers & experten van Voka West-Vlaanderen waar netwerken, inspiratie, kennis en ervaring delen centraal staan. Dit jaar gaat het netwerk op zoek naar de Plato-deelnemer die zijn of haar enthousiasme over Plato het meeste uitdraagt en zich een jaar lang Plato-ambassadeur mag noemen.

20 Nov 2017 Cortana Intelligence in a Nutshell — Part 1

One of the first things we explain to our future customers, is what is available and what is possible with the Cortana Intelligence Suite. With following story we're discussing each product and we give a real-time usage example.

30 Oct 2017 Don’t be afraid to visualise complex business processes

In Business Intelligence we extract data from anywhere. Beside the technical structures that define how the data is stored, we also need to comprehend the business processes behind that structure. It’s all in the name, right?

16 Oct 2017 Use PowerShell to get all the Measures from a 2016 Tabular Cube

With Analysis services 2016 and Analysis Services Management Object (AMO) we now have some powerful tooling to automate our cube with, for example, PowerShell. In fact, it's now even (relatively) easy to retrieve all the measures from a cube in just a few seconds.

02 Oct 2017 Een veilige SQL-database in vijf stappen dankzij Azure

Data beveiligen is de uitdaging van de eeuw. Er zijn tal van momenten en manieren waarop iemand met slechte bedoelingen aan je gegevens kan komen. Je infrastructuur wordt rechtstreeks aangevallen of gebruikers worden overtuigd om schadelijk software te installeren.

18 Sep 2017 How to create your own Power BI visual

In this video our Senior BI Consultant Frederik Aerts is discussing how to start with the creation of your own custom Power BI visual. You can choose from a wide range of default visuals, but you can also create them yourself.

11 Sep 2017 Why I (decided to) work for Kohera

It’s been over a year now since I started working for Kohera and I wanted to share the reasons why I decided to join them. Everyone goes through milestones, crossroads in their life, moments to ponder which road to take for the coming years

04 Sep 2017 Graph Data in SQL 2017

One of the new features in SQL 2017 is a way to save Graph Data. First time I heard the term “graph” I was stunned… Graph Data? First thing, I thought that came into my mind: “Why would you save charts (graphs)”. Nevertheless, that is not what Graph Data is. When we are speaking about Graph Data we are not speaking about tables anymore...

04 Jul 2017 SQL Spot – Part 6

Summer holidays are coming up: perfect timing to take that moment of peace and quiet you had been waiting for and catch up on some of the most recent SQL updates with our monthly SQL Spot. And once again, our thanks to the neverending support and input of  SQL blogging community!

27 Jun 2017 SQL Server Problem Tombola: MAXDOP 1

As you all may know, many vendors tend to force you to put the MAXDOP of your SQL Server to 1 (SAP, SHAREPOINT, AX). Today I would like to demonstrate you the actual impact on your server of setting your MAXDOP to 1.