Koen Verbeeck

240 Followers
152 Following
175 Posts
BI pro and tattooed #sqlserver geek. Data warehousing. I wage war against pie charts. Data Platform MVP. Punk rock fan. Married & father of 2. He/him. Blog at https://sqlkover.com
Would you like bursting to be more configurable in #MicrosoftFabric? Then vote for this idea!
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=22575b35-86eb-ee11-a73e-00224855381e
Microsoft Idea

Get row counts of all tables in a Microsoft Fabric warehouse

I loaded some built-in sample data from Wide World Importers into a Fabric warehouse. You get an option to load sample data when you create a new pipeline in Fabric. It says the data is 352MB in size, but after loading the data I was curious about how many rows were actually in that sample da

Under the kover of business intelligence
Microsoft Fabric Lakehouse Table Maintenance for High Performance

In this tip, we'll discuss the various maintenance options for ensuring performance doesn't degrade for lakehouse tables when using Microsoft Fabric.

MSSQLTips
Check your regions people

Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing came up. I mentioned an F2 is only around €250 a month, but a colleague said "no no, it's over €300". A bit confused, I pulled up the sizing table of my Fabric capacity in Azure, which looks like this

Under the kover of business intelligence
Microsoft Fabric Table Maintenance - Checkpoint and Statistics

Learn about table maintenance in the Fabric Warehouse such as Checkpointing and Statistics and what you should know about these maintenance tasks.

MSSQLTips
Book Review – Deciphering Data Architectures by James Serra https://sqlkover.com/book-review-deciphering-data-architectures/
Book Review - Deciphering Data Architectures

I recently purchased and read the book Deciphering Data Architectures - Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh by James Serra. James - who works for Microsoft since quite some time now - has an interesting blog on data architecture and data warehousing,

Under the kover of business intelligence
New blog post: Fabulous Stuff in #MicrosoftFabric – Part 5: Folders in Workspaces https://sqlkover.com/fabulous-stuff-in-fabric-part-5-folders-in-workspaces/
Fabulous Stuff in Fabric - Part 5: Folders in Workspaces

A while ago I had a little blog post series about cool stuff in Snowflake. I’m doing a similar series now, but this time for Microsoft Fabric. I’m not going to cover the basics of Fabric, hundreds of bloggers have already done that. I’m going to cover little bits & pieces that I find interesting

Under the kover of business intelligence
Automatic #Delta Tables Maintenance in a #MicrosoftFabric Warehouse https://www.mssqltips.com/sqlservertip/7950/automate-delta-tables-maintenance-microsoft-fabric-warehouse/?utm_source=KoenVerbeeck > thanks to Kevin Conan of Microsoft for his valuable input
Automate Delta Tables Maintenance in a Microsoft Fabric Warehouse

Like regular tables in SQL Server, delta tables in a Microsoft Fabric warehouse also need maintenance which we cover how to automate in this article.

MSSQLTips
How to Optimize #PowerBI Semantic Model Performance with Vertipaq Analyzer https://www.sqlservercentral.com/articles/how-to-optimize-power-bi-semantic-model-performance-with-vertipaq-analyzer @SQLServerCentrl > also valid for #MicrosoftFabric
How to Optimize Power BI Semantic Model Performance with Vertipaq Analyzer – SQLServerCentral

Learn how to optimize the size of your Power BI semantic models with the free Vertipaq Analyzer tool. Extra tips & tricks included.

SQLServerCentral
Speaking at dataMinds Saturday & Techorama 2024

I have the pleasure to announce I'll be presenting at two conferences this spring. The first one is at dataMinds Saturday 2024 (back in-person!): Yes, it's a long abstract :) You can register for this free event here. The other session is at Techorama Belgium 2024 where I'll present about

Under the kover of business intelligence