Buenos Aires Code Camp
No, I didn’t attend this one!
My friend Jonas Stawski is the organizer and we’ve been pleased to be a...
2009-10-06
375 reads
No, I didn’t attend this one!
My friend Jonas Stawski is the organizer and we’ve been pleased to be a...
2009-10-06
375 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-10-06
335 reads
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
814 reads
Over the past few years we’ve had a number of recruiters and staffing firms visit oPASS as sponsors, and we...
2009-10-04
347 reads
You can read the full text of it in today’s SSC Newsletter, the quick summary is that for many businesses...
2009-10-02
255 reads
It was nice to work through my email and find a bit of positive news instead of more work! I’m...
2009-10-02
390 reads
There are lots of technical people that are forced to be DBAs by necessity. However there is another class of DBAs, the Incidental DBAs. Andy Warren brings a guest editorial that reminds us about this group of people that work with SQL Server.
2009-10-02
181 reads
In this case making money is about counterfeiting. The Art of Making Money: The Story of a Master Counterfeiter ($18)...
2009-10-01
391 reads
I try not to post too many links without some thoughtful commentary, but I ran across this and thought it...
2009-10-01
273 reads
I’ve had the glimmer of this idea since I posted about the idea of bringing my chair to the 2009...
2009-09-30
1,386 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