I travel a fair amount for work to speak at various events around the world. Traveling can be quite a disruption to my life, and I do work to limit the amount of time that I'm gone. As my kids have gotten older, I'm have less commitments at home and an extra night during a […]
2019-04-11
227 reads
Steve notes that many of us might not completely understand every part of our database, but it's information that can be helpful in cleaning out unnecessary entities.
2019-04-10
564 reads
Steve reminds some people that there are reasons to continue to improve your skills.
2019-04-08
1,824 reads
Phil Factor is excited for SQL Server 2019 and is keen to tell you why.
2019-04-06
692 reads
Azure Data Explorer is a platform from Microsoft that might be an interesting fit
2019-04-05
375 reads
2019-04-04
661 reads
Today we have a guest editorial from Andy Warren that takes another view of the counter offer from your employer.
2019-04-03 (first published: 2015-09-18)
578 reads
Today we have a guest editorial from Andy Warren that looks at the challenge of getting a counter offer from your employer.
2019-04-02 (first published: 2015-09-17)
1,317 reads
Today Steve has an announcement about his role in moving Books Online forward.
2019-04-01
547 reads
Last week was the MVP Summit. This year included a bunch of very technical discussions about some of the future of the Microsoft Data Platform (a big thank you goes to Slava Oks, Bob Ward, and all the team for a great job). I can’t share much since it was all under NDA. All I […]
2019-03-30
508 reads
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
hi everyone I am not sure how to write the query that will produce...
Comments posted to this topic are about the item Rollback vs. Roll Forward
Comments posted to this topic are about the item Foreign Keys - Foes or...
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