A client asked if we could provide a simple form of monitoring on a part of a provided solution. For this particular source, our client asked us to send a simple email with record counts to a mailing list. No problem! Let's get to work
A client asked if we could provide a simple form of monitoring on a part of a provided solution. For this particular source, our client asked us to send a simple email with record counts to a mailing list. No problem! Let's get to work
Sometimes, Databricks can be a bit sluggish. Caching with, for instance, the Delta Cache Accelerated Worker can help you speed it up. We'll explain how it does that.
For some reason developers like stuffing their SQL with SVFs, and that... makes... it... so... slow. Are SVFs really that bad? And is scalar-valued function inlining useful at all? Let’s walk through it together and find out!
While XML has been suitable as a SQL Server native datatype since SQL 2005, for one reason or the other it’s not often used - with only a very few working examples. This blog post is meant for T-SQL teams looking for a working XML example on SQL Server, including schema binding and XML indexes.
What can go wrong when you combine memory-optimized tempdb with the resource governor? If you are using SQL Server 2019 you’ll see that one of the new features allows you to convert some tempdb system tables in in-memory OLTP.
Naar aanleiding van een migratieproject bij een van onze klanten, kreeg ik inspiratie om enkele zaken rond Partitioning uit te klaren. Partitioning is geen performance feature, maar is voornamelijk een methode om het management van grote tabellen te vergemakkelijken.
Allocating budgets on a different level is not easy to manage in DAX. It was (and still is) a DAX struggle for me. This blog post will guide you through the different steps I took to easily manage the different granularities (and write easy DAX afterwards) by allocating budget on day level using Power Query.
Kohera’s Modern Data platform does not come with a canned data model by default. This makes the framework extremely flexible to adapt to a variety of project workflows, but it also means during the Analysis phase we will need to think about how to structure the data before continuing. A blogpost.
Some of our customers want us to import their data from a standard on-premises or cloud-based (Azure) SQL-database, others want us to import their data from a REST API. If ever, you’ll have to import data from a REST API, you’ll surely encounter some obstacles.
Azure SQL Database serverless is a new compute tier made for single databases. This new model automatically scales the compute based on the actual workload per second. This means that you only have to pay for the compute resources (memory & vCores) you use. But there's more...
In a previous blogpost, we already explained how to make a date table in Power BI with DAX. Besides the dates you can add extra properties for each date: year, month-names, weekday-names,... But what about hours and minutes? In this blog and video, we'll show you how to create time tables in Power BI.
31 december was het zo ver, we zaten aan de radio gekluisterd om de Tijdloze op de voet te volgen. Op plaats 93 noteerden we onze eerste voltreffer en hoe dichter we bij de top 10 kwamen, hoe beter onze voorspelling . Negen van de tien nummers uit de top 10 hadden we voorspeld en drie hiervan hadden de voorspelde ranking.
Waar we vorige jaren begin januari in actie schoten, staken we nu reeds in december de handen uit de mouwen. Aan de hand van een predictieve analyse doen we een poging om De Tijdloze 2019 te voorspellen, niet enkel de top 3 maar de ganse lijst.
Tired of logging on to Azure Data Factory every day and checking the status of your pipeline(s)? In this blog, Data Wizard Wout Cardoen shows you how to develop an automatic email that alerts you when a pipeline fails.
Azure Databricks is a cloud native (Big) Data analytics service, offered as a managed PaaS environment. It’s designed to hide the underlying distributed systems and networking complexity as much as possible from the end user, so you can focus on developing rather than having to stress over infrastructure management.
When I started to jump from DBA to Data Architect, I thought that these roles would diverge further and further until they became two separate roles and functions. The current evolution Microsoft launched proved me wrong though. Enter Azure Synapse Analytics.
Recently our data wizard Thomas Costers was at a customer who created an indexed view, which spanned multiple tables as part of a release. Because you can't disable lock escalation for an indexed view as you can for a table, he went looking for another solution.
In our latest How To video, our BI wizard Frederik Aerts, integrates the data of his Fitbit into Microsoft Power BI. There are different ways to do it... Enjoy!!