Custard Indexes
Not sure how or why this popped into my head (and too late for April Fools!), but it amuses me...
2018-04-13
454 reads
Not sure how or why this popped into my head (and too late for April Fools!), but it amuses me...
2018-04-13
454 reads
Robert Davis (@SQLSoldier) died on Monday. A great technical guy, he did a lot of writing and presenting and answering...
2018-04-13 (first published: 2018-04-04)
3,121 reads
Just crossed off my quarterly goal of planning SQLSaturday attendance for the next quarter (I’m writing this on March 31st!)....
2018-04-02
298 reads
In February PASS President Grant Fritchey posted PASS Priorities FY 19 followed by An Open Letter to SQLSaturday Organizers, and then held...
2018-03-30 (first published: 2018-03-27)
1,707 reads
It’s early days for thinking about the Summit, but as I wrote the post for yesterday about not submitting I...
2018-03-30
456 reads
I had three ideas I considered submitting this year:
Devops for the DBASQL ChecklistsLearning Plans v2I’ve presented the first topic a...
2018-03-29
265 reads
Just a quick note that we’ve reserved the date for our 12th SQLSaturday here in Orlando. It will be held...
2018-03-28
281 reads
Quick notes:
Same location as previous years, good!Parking was same place, but it was confused by a pay-to-park event on the...
2018-03-26
282 reads
Good crowd, well organizedTook down registration early, perhaps 10 am, and that confused a few late(r) attendees (I like to...
2018-03-18
159 reads
My friend Tom died yesterday. I just heard the news a few hours ago and while it will take some...
2018-01-31
773 reads
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
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)...
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