SQLSaturday #6 in Cleveland - Registration Open
Long time acquaintance Allen White is hosting SQLSaturday #6 in Cleveland on August 9th. Registration and call for speakers is...
2008-06-12
440 reads
Long time acquaintance Allen White is hosting SQLSaturday #6 in Cleveland on August 9th. Registration and call for speakers is...
2008-06-12
440 reads
At the recent SQLSaturday #4 we had a session end up finishing much earlier than expected, so we gave the...
2008-06-11
702 reads
Just received this from my friend John Magnabosco about the SQL portion of the event:
Business Intelligence Track - TBD (Arie Jones,...
2008-06-10
492 reads
It's a rite of passage in our business that we have to learn the RAID levels, and I still enjoy...
2008-06-09
505 reads
Shawn Weisfeld has been the President of ONETUG (Orlando .Net Users Group) for the past three years and has just...
2008-06-08
478 reads
Attendance on Saturday about 450 across the communities (SQL, .Net, DNN, etc). Not as big as we'd hoped, but still...
2008-06-08
433 reads
One of the big themes this year for Microsoft (and I just saw it on the PASS Summit site) is...
2008-06-05
705 reads
Our main presentation was on 'Unlocking the Power of SQL Compact' by Steve Lasker & Ginny Caughey. Went better than I expected...
2008-06-04
421 reads
First, the usual disclaimer: I'm not a financial professional, so take all of the following with a grain of salt...
2008-06-03
747 reads
Just took a look at the World Wild Telescope and it looks interesting, perhaps just as importantly looks cool! Don't...
2008-06-03
437 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