Some time ago, a client came up with a very intriguing question. As I love a challenge, especially when you get to dig deep into a toolset, I jumped at the occasion and went for it. The following is a write up about the steps taken to analyse. Both for future me when I run … Continue reading Azure Synapse Analytics performance, an analysis
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
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
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
Hi! 2024 is (almost) over and we're heading into the preview of 2025. Let's see how we get through this trial period of the new year. Let's start with looking back on the year that's behind us all. What a year it’s been! 2024 had a lot going for it, also enough things to, as … Continue reading 2024 in review, 2025 in preview
In one of the earlier blogs, the topic revolved around everything Git. Git is a version control system where you can leverage CI/CD. I love Git, even though it has a habit of biting me severely in the parts I use to sit on. If you're not well versed in Git or have no option … Continue reading DP-700 training: Create and configure deployment pipelines
