In a blog from a few weeks ago, I wrote about getting data from your on-prem SQL Server into Fabric. At the time, the only option for a copy dataflow was using a direct connection over the internet. It still is, but now you can also use the PowerBI Data Gateway to get data from … Continue reading Getting on-premises data into Microsoft Fabric using the data gateway
A few days ago, I heard the term table clone for the first time, it's preview release date was to be confirmed and I had no idea what it was about. Two days later, a video emerged where the table clone was explained on a high level. At that point, I started to wonder what … Continue reading Microsoft Fabric: shortcuts and table clones
In my previous blogs, I've written about Fabric and all the cool things it can do. Thing is, my load tests were based on files. Either CSV or Delta. But in reality, a lot of data comes from an on-premises database server. In reality, you might connect to a SQL 2008 instance or maybe even … Continue reading Microsoft Fabric, connect to your on-premises SQL Server
In my previous four blogposts, I've shared some first impressions and small things I discovered since the preview release. Again, the preview release. New features are added, bugs are fixed and additions are released. When I asked if there's a GA release date, there was no answer. And I can guess why, it's hard to … Continue reading Microsoft Fabric, impact on my daily work
When Fabric released, there was a lot of noise around it. Many people have written blogs, created YouTube video's and all kinds of other interesting things to share the love of this new tooling. Well, new? Especially when you look at Fabric data warehouse, it's more of an iteration over Synapse Analytics Serverless Pools. As … Continue reading Microsoft Fabric, Data Warehouse first impressions
In my previous blog, I wrote about some first impression working with Fabric and mostly following the Lakehouse tutorial provided by Microsoft. Well structured as this one may be, the sizes are not like the sizes I'm seeing in the wild. So I decided to give Fabric a bit more of a challenge by letting … Continue reading Microsoft Fabric, fooling around with TPC-H data
This Week, Microsoft released the new Fabric resource on Azure. It's been hard to miss as many MVP's were tweeting, Mastodoning and sending messages on LinkedIn that Build should not be missed this year. So yeah, it was clear something huge was going to happen. When the announcement came, I was outside. My kid had … Continue reading Microsoft Fabric, first impressions
It's been some time since my last post on Azure Data Factory, but I had some fun this week and wanted to share the learnings. This blog will cover how I read files from an sFTP site, use the copy activity if the file hasn't been processed yet and write some data into a table … Continue reading Learning ADF Part 6
Last year, I wrote a blog about speaking, helping and attending at SQL Bits. Of course, I wanted to repeat that experience but my sessions weren't selected. So this time I was helping and attending. In a few blogs I saw names of people that stood out. I won't name many for the simple reason … Continue reading Attending and helping at SQL Bits 2023
In one of my last blogs, I wrote about my first encounter with the Azure Hyperscale Serverless offering. Now it's time to dig a bit deeper and what it's up to. Disclaimer. Azure Hyperscale Serverless is in preview and one of the things that isn't active yet, is the auto shutdown. This means that it … Continue reading Fooling around with TPC-H data, ADF and Hyperscale Serverless
Reitse's blog 