Ramblings about data communities and your contributions, no excuses
I have been active in the data community throughout my career. I have met people and made friends in the process. As I look back on it, I am...
2026-02-26
17 reads
I have been active in the data community throughout my career. I have met people and made friends in the process. As I look back on it, I am...
2026-02-26
17 reads
Ramblings of a retired data architect Let me start by saying that I have been working with data for over thirty years. I think that just means I am...
2026-01-23 (first published: 2026-01-12)
425 reads
I can’t believe it’s finally here! A way to have Excel live in OneDrive and access it from Power BI nearly live! We can officially short cut files to...
2025-12-26 (first published: 2025-12-05)
379 reads
It has been a while since my last T-SQL Tuesday blog. When I saw Mike Walsh’s topic for T-SQL Tuesday #193, I was intrigued and inspired – “Notes to...
2025-12-24 (first published: 2025-12-09)
230 reads
When I created the website on WordPress, I was expecting all the features I had on our WordPress.com which powers this website. As I called out in my previous...
2025-11-21 (first published: 2025-11-20)
20 reads
Holy cow FabCon Vienna was incredible! This recap is extremely delayed because I’ve run into some serious decision fatigue about what to include (and my amazing hubby got me...
2025-11-18
13 reads
Over the past few months, I have debated starting a new blog to discuss our ALS journey. I realized we were writing about ALS on the Data on Wheels...
2025-11-08
15 reads
Had an incredible time at DevUp in St. Louis this weekend! This conference gets better and better each year and draws in some incredible folks from all over the...
2025-08-29 (first published: 2025-08-08)
124 reads
This weekend was one of my favorite Data Saturday events, Data Saturday Columbus! If you’re in the area, I highly recommend it. Always some great speakers, amazing lunch, and...
2025-08-19
13 reads
SQL Saturday Baton Rouge is a great event hosted on LSU’s campus that has some of the best food, presenters, and attendees in the country! Had some incredible questions...
2025-07-26
41 reads
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers