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
Let me set the scene quickly for you. You're working for an organisation where Fabric is in the process of being adopted or it's already fully in use. Regardless of the number of capacities, workspaces, etc, you're interested in what's going on in your Fabric environment. You have questions like "Who is using the reports?", … Continue reading Streamline Fabric Monitoring and Administration Using FUAM
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
Today, May 19th, 2025, is the keynote day of Microsoft Build, where Microsoft announces its big new tech innovations. You won't be surprised; there's a lot of Copilot in the announcements. You can't get around it if you have any toolset in the cloud; there will be AI waiting for you to help you. Bad … Continue reading Is Microsoft SSMS Copilot the Future of Database Management?
Some time ago, I wrote a number of blog posts 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). I did this by creating data in the database and reviewing the metrics. This worked well 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
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
This month, Kevin Chant has a really fun writing challenge for us. Not only is it a very inspiring call to write about SQL Server (my choice), but it's also a crossover between T-SQL Tuesday and the Festive Tech Calendar. It's like opening a digital present! Kevin created a very nice image that shows the … Continue reading T-SQL Tuesday #181 The Data Platform Present
In the previous blog, you read about the Spark settings within the workspace. This time it's about the domain settings. So let's dig into what domains are, what you can use them for and which settings there are. What are domains? If you read (and you should) the excellent book on data architectures by James … Continue reading DP-700 exam training: Configure Domain workspace settings
