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
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
By the time you read this, I'm guessing the big #MSIgnite announcements were yesterday. You can use that hashtag to find most of the posts on social media. And there were many, very cool, announcements! Let me quickly take you through my favourites. Databases! As I still love the DBA work, announcing SQL Server 2025 … Continue reading Top Highlights from #MSIgnite 2024
OneLake, the OneDrive for all your data, the One Lake to rule them all or however you've heard it being described. Whatever you've heard, OneLake is the single storage on your tenant used to store all the data of your Fabric Capacities. About OneLake The core point to remember is that your tenant has just … Continue reading DP-700 Exam training: Configure OneLake workspace settings
I had an interesting question lately where I was requested to show all the network traffic within an Azure landing zone. Specifically source and target IP, protocol and port. From the aspect of Zero Trust, it's important to show both successful and failed connections in your network. To be able to answer this question I … Continue reading Analyze Azure NSG Flow Logs in SQL Server: Step-by-Step Guide
About two weeks ago, the DP-700 (Microsoft Fabric Data Engineer) went into beta. This means that curious people like me can take the exam, see what's in it and provide feedback to the people who wrote the questions. To add to fun, I decided to take the exam online as the exam centres close by … Continue reading What to Expect from the DP-700 Microsoft Certification Exam
For those of you who either attended Fabric Conference Europe and/or have some sort of social media account, it won't come as a huge surprise that Microsoft is launching a new certification. If you're working with Microsoft Fabric and focusing on the data engineering part of things, this certification is for you! What is it? … Continue reading Mastering the DP-700: Your Guide to Microsoft Fabric Certification
This blog won't be very long and will describe a connection issue I experienced with a customer including the solution and some context why this solution worked. I hope this saves you time when dealing with the same error. Issue The customer can connect to the Azure Sql database with Sql Server Management Studio (SSMS) … Continue reading Fixing Azure SQL Client Connection Timeouts
Reitse's blog 