Category: ETL

DP-700 training: Choose between query acceleration for OneLake shortcuts and standard OneLake shortcuts in Real-Time Intelligence

A three-line title that promises a lot! So let's try to simplify this a bit. In essence, this blog will cover how to make OneLake data quicker in an Eventhouse using shortcuts. The process, at a high level, is quite simple. In your eventhouse, create a shortcut to a Lakehouse, for instance. Enable query acceleration, … Continue reading DP-700 training: Choose between query acceleration for OneLake shortcuts and standard OneLake shortcuts in Real-Time Intelligence →

Mirroring SQL Server 2025 to Microsoft Fabric, a level deeper

Maybe you've read my blog post in the DP-700 certification series about mirroring data. You can find that one here. This blog will be longer and more technical. And involve SQL Server. To make reading a little easier, I've listed the Microsoft Learn pages at the end of this blog post. While writing the DP-700 … Continue reading Mirroring SQL Server 2025 to Microsoft Fabric, a level deeper →

Microsoft Realtime Intelligence: the array that wasn’t

In a previous blog, I wrote about processing XML and that it's actually JSON after the first pass. So far, so good. But then I found out that not all data was returned. That's weird because it's really there. So, what's happening here? Follow me, and let's find out! The previous blog had this JSON … Continue reading Microsoft Realtime Intelligence: the array that wasn’t →

Loadtesting Microsoft Fabric, part II

This blog can also be known as 'The Sequel', not to be confused with SQL, even though Fabric SQL will be mentioned in this blog. Anyway, I digress and don't call me Shirley. For those of you who have been following this blog for a long time, you may have read the posts on Fabric … Continue reading Loadtesting Microsoft Fabric, part II →

DP-700 training: Orchestration

"tap tap tap". Your attention please, we're going to orchestrate our ETL/ELT process! Yes, it's time to unleash your inner Herbert von Karajan and make sure your BI orchestra performs at its best. Why? Well, unless you enjoy waking up every night to start your Extract-Transform-Load (ETL) process and manually running each process to do … Continue reading DP-700 training: Orchestration →

Ignite announced SQL Server 2025 and Fabric SQL GA

I'm guessing you've seen posts, blogs and social media activity in the last year on both Fabric SQL databases and rumours around SQL Server 2025. Today, Microsoft announced that both of these are Generally Available (GA). This means it's now fully supported by Microsoft. You can read all about this, and more, in the Ignite … Continue reading Ignite announced SQL Server 2025 and Fabric SQL GA →

SSMS 22 preview 1 first impressions

We're almost used to SQL Server Management Studio (SSMS) 21, and now 22 is already in preview. So, let's see where it's available for download, install it and see what's different. Download and release notes. The most important part, of course, is the download of the binaries. Click here for the download. Click here for … Continue reading SSMS 22 preview 1 first impressions →

SQL Server 2025: Simplifying Data Checks with RegEx

One of the new features in SQL Server 2025 is that you can now use regular expressions directly in your T-SQL queries. Now, regular expressions (or RegEx) have never been a syntax that's easy to read. There are a lot of brackets, dashes and other symbols that make no sense when you first see them. … Continue reading SQL Server 2025: Simplifying Data Checks with RegEx →

My top features of SQL Server 2025 for Business Intelligence

Some time ago, Microsoft announced the release of a new version of SQL Server. This made me happy, mainly because in the storm of everything Fabric, Copilot, and cloud, sturdy technology still has a place, and Microsoft hasn't forgotten that. Companies still rely on on-premises systems that require databases. And running everything on-premises is still … Continue reading My top features of SQL Server 2025 for Business Intelligence →

Mastering Real-Time Analytics with Microsoft Fabric

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 →