Monitoring costs in Microsoft Fabric can be trickier than it first appears. You might assume it’s just a flat fee per capacity (easy, right?), but real-world usage tends to...
2026-02-23 (first published: 2025-12-24)
244 reads
A few weeks ago, I found myself staring at a slide full of new Microsoft AI names and thinking… wait a second. Work IQ. Fabric IQ. Foundry IQ. Agent...
2026-02-12
12 reads
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting governance. With Fabric OneLake and open table formats like Iceberg and Delta, there are now...
2026-02-09 (first published: 2026-01-29)
297 reads
I remember a meeting where a client’s CEO leaned in and asked me, “So, we have tons of data… Why can’t we just add AI and call it a...
2026-01-28 (first published: 2026-01-14)
291 reads
Announced at Microsoft Ignite two weeks ago were many new product features related to the data platform. Check out the Major announcements and Book of News. I went through the many announcements and picked...
2025-12-10 (first published: 2025-12-02)
373 reads
I had a great question asked of me the other day and thought I would turn the answer into a blog post. The question is “I’m an experienced DBA...
2025-11-12
14 reads
I still see a lot of confusion about the functionality of Microsoft Purview ever since multiple products were combined into it, so I wanted to write this blog to...
2025-11-10 (first published: 2025-10-15)
625 reads
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community Conference (FabCon Vienna) recently. Here are all the new features that I found most interesting, with...
2025-10-17 (first published: 2025-09-24)
1,603 reads
(Side note: Excited to share that the audio version of my book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” is...
2025-10-01 (first published: 2025-09-09)
599 reads
I want to talk about a fairly new product that you may not be aware of: Azure IoT Operations, which GA’d last November (it was first announced at Ignite...
2025-09-03 (first published: 2025-08-19)
780 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers