When Microsoft Fabric was introduced in May 2023, one of its major promoted components was the Real-time Analytics part. We (that is, my coworkers and I from Axians) focused mainly on the batch processing of data. With the introduction of the DP-700 exam, I started to focus more on the real-time part of Microsoft Fabric. … Continue reading Mastering Real-Time Analytics with Microsoft Fabric
Let's dig into something that's quite simple to implement: workspace monitoring. Whenever someone calls out that "something is simple to implement", your first response should be "Oh really?". Because simplicity is always in the eyes of the beholder. And sometimes the easiest solutions carry the most consequences. Or cost. Or both. Wording can be complicated, … Continue reading DP-700 training: Workspace logging
If you come from an SQL Server background, mirroring will be familiar to you. It may be good or bad, but hopefully not at a nightmare level. Whatever your association with database mirroring, it is also available within Microsoft Fabric. What is mirroring If you're not coming from a SQL Server background, or any data … Continue reading DP-700 training: Implement mirroring
Now that's a title! Especially for a very cool new feature: Copilot embedded in SSMS. I've blogged about Copilot for SQL before, but this really is the next step! I'm very excited about this new feature, and I tried to install it on my machine. Because Microsoft can share all the steps they think you … Continue reading Setting Up Copilot in SSMS 21: A Step-by-Step Guide
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
