Most enterprise questions do not live neatly in one place. The numbers may be in a warehouse, the rules may be buried in PDF files, and the explanation may...
2026-09-09 (first published: 2026-09-03)
280 reads
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform. Power BI, data engineering, warehousing, data science, real-time analytics, Copilot, and other experiences can all...
2026-08-28 (first published: 2026-08-20)
468 reads
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales owns sales transactions, Finance owns budgets, and Shared Data owns common tables such as Customer,...
2026-08-06
196 reads
Originally published April 2022; substantially updated July 2026. This post is a complete replacement for and update to my April 2022 post, Power BI Performance Features. That post focused...
2026-08-03 (first published: 2026-07-23)
994 reads
It can feel as if Microsoft has put the Copilot name everywhere, and that is not far from the truth. The important thing to understand is that Microsoft Copilot...
2026-07-27 (first published: 2026-07-16)
435 reads
The idea behind Fabric OneLake Security (which GA’d on April 2026) is to centralize data access controls at the data layer, rather than configuring security separately for every Fabric...
2026-07-06
62 reads
Once again there were a number of Microsoft Build announcements related to data and AI, and some were very impressive. Below are my favorites. I am prioritizing the data...
2026-07-01 (first published: 2026-06-18)
458 reads
Microsoft Purview can be the best data governance tool in the world, but it will still be useless if people do not know it exists, do not trust the...
2026-06-04
115 reads
Since the release of my book Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh, I’ve been fortunate to hear from readers...
2026-06-02
69 reads
What problem is Fabric Ontology trying to solve? For years, most data conversations have started with tables. We ask where the data lives, what columns are available, how the...
2026-06-10 (first published: 2026-05-20)
422 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Comments posted to this topic are about the item AI Experience Gap that we...
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