Understanding Fabric MCP
Model Context Protocol, or MCP, is one of those technical ideas that sounds more complicated than it really is. The easiest way to think about it is this: MCP...
2026-05-20 (first published: 2026-05-04)
505 reads
James Serra's Blog
GenAI vs Dashboards: Not the Same (And Never Will Be)
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric, and Fabric data agents become part of everyday conversations with customers: will GenAI replace reports...
2026-05-06 (first published: 2026-04-23)
380 reads
The OneLake catalog in Fabric: Explore, Govern, Secure
Once your Fabric tenant grows past a few workspaces, data discovery gets weird fast. Duplicates multiply. People stop trusting what they find. And security teams start hearing things like,...
2026-04-14
39 reads
Announcements from the Microsoft Fabric Community Conference
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community Conference (FabCon Atlanta 26) last week (see the FabCon keynote here). There were 8000 attendees! Here...
2026-04-08 (first published: 2026-03-26)
1,500 reads
T-SQL Tuesday #196 Roundup: What career risks have you taken?
I hosted this month’s T-SQL Tuesday invitation in which I asked, “What career risks have you taken?” I got some great responses which I’ll recap here, Career risks? Rob...
2026-03-17
31 reads
Semantic Model Power Query vs Dataflow Gen2 in Fabric
In my recent blog post, Building Power BI Reports: Desktop vs Fabric, I talked about the evolving authoring experience in Microsoft Fabric and how report development is increasingly moving...
2026-03-09
72 reads
T-SQL Tuesday #192: What career risks have you taken?
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may not know the history, T-SQL Tuesday started back in December 2009 when Adam Machanic (Blog |LinkedIn)...
2026-03-03
24 reads
Building Power BI Reports: Desktop vs Fabric
Why this comparison feels confusing If you’re a Power BI report author who’s just getting into Microsoft Fabric, you’ve probably asked the same question I hear over and over:...
2026-03-09 (first published: 2026-02-26)
591 reads
Making Sense of Microsoft’s AI Strategy: Work IQ, Fabric IQ, Foundry IQ
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
40 reads
Three Ways to Use Snowflake Data in Microsoft Fabric
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)
353 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Kontak Bank BCA KCP Purwosari [083178278662]
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
Alamat Bank BCA KCP Palur [083178278662]
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers