Some time ago, I wrote a number of blogposts comparing the different Azure SQL options to give you some idea about performance, differences between tiers and differences between the Stock Keeping Units (SKU's). This was done by creating data in the database itself and review the metrics. This works fine and gave a good overview … Continue reading Loadtesting SQL, the sequel
Data security is the most important part of our job as data engineers and data architects. There are very few use cases where people need to see all the data in full detail. I know, customers take a different view on this but in reality, do they really need every single detail? No, they do … Continue reading DP-700 training: data masking
The best place to store your data is in a SQL Server database that no living being can ever access. The end. No, I'm kidding, of course. But there's an atom of truth in this joke. Because for years we, in the structured data industry, have always been convinced that a database is the best … Continue reading DP-700 Training: Choose an appropriate data store
Welcome to my Ted Talk, data transformation is done in T-SQL. Thank you. Well, yes once upon a time, maybe. Nowadays there are many more ways that lead to the dark side (also known as data vault) and the happy side (also known as the star schema or dimensional model). Did I lose you yet? … Continue reading DP-700 Training: Data transformation options
Last week, I had the pleasure to help and speak at Fabric February in Oslo, directly followed by Data Saturday Denmark. This post will guide your through my experiences in these events. At the end, I'll touch on some mental health things. Fabric February If you're unfamiliar with Fabric February, the core of the conference … Continue reading Speaking experiences at Fabric February and Data Saturday Denmark
This weekend, attending Data Saturday Denmark, I joined a session presented by Benni de Jagere. Benni works for Microsoft as a member of the CAT team but is also very active in the community as an organiser and speaker. In general, when Benni starts speaking and sharing knowledge, it's well worth it to listen and … Continue reading Mastering your Fabric Capacity Metrics App
Now that's a long title! Luckily, this concept isn't really hard so you should be in for a smooth ride today. What is this easy thing? Well, to put it quite simple, you can add three labels to items in your Fabric workspace:- Promoted- Certified- Master Data In my view, there's an order to these … Continue reading DP-700 Training: endorse, promote and certify your items
This post can come as a shock if you're used to writing T-SQL. Because not only is there more than one useful language to process data, realtime data in this case, but it also has enough similarities to SQL to look familiar and is different enough to leave you flustered. Now, to get a complete … Continue reading DP-700 Training: Process data using KQL
Let's start this blog with a personal opinion: I love windowing functions. Sounds like a good start of this post? Cool, let's keep going. What is a windowing function? There's a lot you can read about it, but in short it comes down to creating a subset in your query result where you apply a … Continue reading DP-700 training: create windowing functions
Microsoft Fabric really is a Swiss army knife when it comes to its possibilities. Not only capable of hosting your BI information which is usually loaded at night and analysed during working hours but it can also process real time information. Let's dig into that some more! Data Fabric architecture Before we go all nerdy … Continue reading DP-700 training: exploring event streams
Reitse's blog 