Improve Query Performance in the Fabric Warehouse with Clustering Learn how to improve performance issues in Microsoft Fabric Warehouse and leverage cloud-based data analytics effectively.

New article: Improve Query Performance in the #MicrosoftFabric Warehouse with Clustering www.mssqltips.com/sqlservertip...

Fabric Mirroring doesn't start copying Rows A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I've managed to run into, twice. I've set up mirroring by creating a connection using a service principal ...

New blog post: #MicrosoftFabric #Mirroring doesn’t start copying Rows sqlkover.com/fabric-mirro... #sqlserver

Rookie mistake, AI, rookie mistake... #sqlserver

People pay most attention when there's a slide change. Each new slide gains you around 20 seconds of guaranteed attention.

If you're planning to spend 5 minutes on the same slide, you need to be REALLY good to keep everyone's attention. 2/2

Free public speaking tip:

You can make the talk more engaging without changing its content simply by spreading the information across more slides. 1/?

Microsoft Fabric Frequently Asked Questions Find answers to your questions in our Microsoft Fabric FAQs. Learn about features and capabilities of this powerful data platform.

New articles: #MicrosoftFabric FAQ www.mssqltips.com/sqlservertip... + one about architecture www.mssqltips.com/sqlservertip...

AI tools are demanding fighter pilot-level cognitive multitasking from every knowledge worker. We're neither selected for it nor trained for it - and a new Berkeley study suggests we're paying the price without anyone noticing.

arcticdba.se/posts/more-s...

#AI #Cognition

Imagine short women said “Women over 5'4 (1.60m) shouldn’t play pro basketball because they have a genetic advantage over REAL women” and people responded with “Well, studies show height reduction surgery eliminates the advantage” instead of “Did Smurfette just say tall women aren’t real women?”

What a horrible title 🤮

Giving a star schema all the things talk later today btw 😅

If you get 4 as a total while expecting 2, I suppose the measure was not defined correctly. DISTINCTCOUNT instead of SUM or something like that.

Webinar Series - SQL Server Indexing I'm starting a webinar series about SQL Server indexing with the fine folks of MSSQLTips.com. Each "episode" will be about 30 minutes long and will feature a certain topic of indexes in SQL Server (or...

Webinar Series at MSSQLTips.com – #SQLServer Indexing sqlkover.com/webinar-seri... > free to attend, a gentle introduction to indexes

Calculate Rolling Average with SQL DATE_BUCKET Function Understand how to use DATE_BUCKET SQL command to group dates and calculate averages in T-SQL for your sales data analysis.

Calculate Rolling Average with #SQL DATE_BUCKET Function > in the #MicrosoftFabric Warehouse #sqlserver www.mssqltips.com/sqlservertip...

Downgraded to previous version and now models open again.

Alright, who broke #PowerBI Desktop? All models that I open with the March edition get this error.

Imagine the musical where some goths are doing their "1-tile-dance" on some new wave :)

If the agent is a human, I'd expect less than 10 mins. If chatbot, immediately.

They expire?

Stuff like this shouldn't be that hard. It's like MS is deliberately throwing hurdles in the path to a true enterprise data platform.

The MI is part of the security group in the tenant setting you mentioned and contributor on the workspace, but still the pipeline fails. Annoying. I'm thinking it's the notebook activity in the pipeline that is causing this, hence the need to use a notebook connection.

I'd rather use something that doesn't have secrets that expire. The thing I want to solve is that I want to trigger a Fabric Pipeline from ADF using the ADF managed identity, but for some reason the pipeline fails (again with user token issue).

I get that you need to do this for service principals, but workspace identities? They're part of the system itself (yes, I know they're service principals behind the scenes).

OK, that's annoying as we work with a new workspace for each git branch, and each time adding the workspace identity to the security group is major overhead since we cannot do this ourselves (and we don't have this Entra ID permission at most of our clients)

anyone got the new notebook connection working with a workspace identity from a data pipeline? #microsoftfabric cc @erwindekreuk.bsky.social

You would think that if you run your own #MicrosoftFabric capacity, that queueing would be less...

Oh wait, I've read the entire thing now. Yes, it's that time of the year again 😅

Nope, we change on the 29th of March.

I’m Not Gonna Waste Time Debunking Crap on LinkedIn. LinkedIn is full of absolute trash these days. Just flat out bullshit garbage. (Oh yeah, that - this post should probably come with a language disclaimer, because this stuff makes me mad.) People wanna look impressive without actually putting in the work to gain real knowledge. They're asking ChatGPT to write viral "expertise" knowledge posts for them, and they're publishing this slop without so much as testing it.

I’m Not Gonna Waste Time Debunking Crap on LinkedIn.

LinkedIn is full of absolute trash these days. Just flat out bullshit garbage. (Oh yeah, that - this post should probably come with a language disclaimer, because this stuff makes me mad.) People wanna look impressive without actually putting in…

There are so many of these crap posts nowadays in my feed. "SQL Logical query order" "Why you should use CTEs" "How to remove duplicate rows" and so on. @drsql.bsky.social has apparently the patience of an angel to comment on them to point out mistakes :)

ADF Pipeline Debugging Fails with BadRequest - The Sequel A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you're wondering, this is the helpful error message th...

New blog post: #Azure Data Factory Pipeline Debugging Fails with #BadRequest – The Sequel sqlkover.com/adf-pipeline...