This monday, I was lucky enough to attend the Fabric level 300 precon at dataMindsConnect. If you ever have the chance to go there, do it! It's very well organised, the sessions are amazing and so are all the people there. But that's not what this blog is about; today a Twitter thread started on … Continue reading Microsoft Fabric, capacity usage and a design
Category: DBA
Microsoft Fabric: shortcuts and table clones
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
T-SQL Tuesday #164: Code that made you feel a way
This month, Erik Darling (T | L | B) asks us to write about code that made us feel a way. Rule is, it can't be your own code. That's good, because that usually makes me a bit sad when I review it. The moment I write it, I think it's brilliant though ;). Most … Continue reading T-SQL Tuesday #164: Code that made you feel a way
View with a where clause
I was teaching a class and during an interesting discussing an attendee told me that views with a filter took a long time to produce results, even if the result set itself was quite small. I wanted to test this out for myself to see what was happening. I'll take you along this short journey … Continue reading View with a where clause
Microsoft Fabric, impact on my daily work
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
Microsoft Fabric, Data Warehouse first impressions
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
Speaking experiences at Data Saturday Stockholm
Last year I had the honour of speaking in both Gothenburg and Oslo, this year Stockholm got added to this wonderful list of Scandinavian countries. The event is headed by Daniel Hutmacher, his wife Ewa Hutmacher and Alexander Arvidsson. Three people who really care for the event and everyone in it. And this shows in … Continue reading Speaking experiences at Data Saturday Stockholm
Microsoft Fabric, connect SQL Server Management Studio, Azure Data Studio or Windows Explorer to your OneLake
Whilst working on a blogpost on Fabric Data Warehouse, I started wondering if I could work around the SQL web interface and connect to my OneLake with SSMS and/or ADS. As it turns out, you can! Find the connection-string To be honest, this was the hardest part as the connection-string is somewhat hidden. In your … Continue reading Microsoft Fabric, connect SQL Server Management Studio, Azure Data Studio or Windows Explorer to your OneLake
Microsoft Fabric, fooling around with TPC-H data
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
Fooling around with TPC-H data, ADF and Hyperscale Serverless
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









