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.
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: batch mode adaptive joins, batch mode memory grant feedback and interleaved execution for multi-statement table valued functions.
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.
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.
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.
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 started looking some things up. How many kilometers must the Belgium football team travel to play their matches? After I read some documentation, I started thinking on how spatial data could be used with some ‘real life’ examples. As it happens, I created a fun dashboard in Power Bi with my colleague about the upcoming World Cup in Russia.
Clusterless Availability Groups
SQL Server 2017 came with a couple of enhancements regarding Always On Availability Groups. For example, we can now specify the minimum number of secondary replicas that need to have written the transaction data to their log before the primary replica commits.
Efficient and clear-cut monitoring of your databases with SQL Operations Studio
A while ago, Microsoft released a preview version of SQL Operations Studio. This new software package is supposed to simplify database management by putting frequently used queries into an organized dashboard.
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 and one of my slides was the following. This picture was taken and I found that it was quite a nice topic to write something about. So here we are! In Azure there are 3 different big data stores that you can use and in this blog post I want to explain the differences between them.
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. That’s the example that we will be demonstrating in this blog. In the second part of the blog, we’ll try to do the same with an open Power BI file.
