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
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
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
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
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
As some of you know, I've written a series of blog posts on Azure SQL Databases and there's an accompanying session that I had the honour of presenting a number of times. Now Azure keeps developing new offers and one of these went in public preview February 15th. An offer I hadn't seen coming. You … Continue reading Azure Hyperscale Serverless, first impressions
This month Deepthi Goguri invites us (the community) to write about two topics: our favourite new feature of SQL Server 2022 and your new years resolutions. You can find her blog here, her LinkedIn profile here and she's also on Twitter here. Favourite new SQL Server 2022 feature Most of my work is in data … Continue reading T-SQL Tuesday #159 – What’s Your New Favourite Feature?
A few days ago, I heard someone stating that Group By was much quicker than Distinct. Less disk impact, less memory etc.So, I thought I'd find out if it's true or not because I found it interesting. I always thought there was no difference. I tested a single small table and found no difference in … Continue reading Distinct or Group By?
Getting data from an API can be hard, especially when you're trying to get data from a so-called Soap interface. This is a bit of an antique way to distribute data to online applications and has a lot of challenges. I've read a few blogs on this subject but funnily enough, they're all using the … Continue reading Azure Data Factory and Soap, an opera?
It's the end of the year, the beginning of a new one. Time to look back and see what happened and plot a course forward. 2022, the downs Let's get started with the bad stuff, get it over with. As some as you know, my mother got diagnosed with Alzheimer's disease. This is a process … Continue reading 2022 in review, 2023 in preview
Reitse's blog 