Don’t Be This Guy
I have a sad story to tell you. Sit down and grab a tissue.
It was 10pm on a cool night...
2009-10-29
702 reads
I have a sad story to tell you. Sit down and grab a tissue.
It was 10pm on a cool night...
2009-10-29
702 reads
In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...
2009-10-28
1,858 reads
Anyone who has an Internet connection has kept up with PASS-related news during the past couple of weeks is keenly...
2009-10-22
777 reads
If you meet me at PASS, you can win prizes!
OK, so maybe there’s a little more to it than that. ...
2009-10-21
714 reads
Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant. While we caught up, he asked me to explain in terms he could understand what I do for a living. I went through one of my spiels (the one usually..
2009-10-21
1,724 reads
Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant. While we caught...
2009-10-19
820 reads
Earlier this week, I delivered a presentation entitled “Deploying Report Builder 2.0 for Self-Service Reporting” as part of the new...
2009-10-14
661 reads
If you are a blogger and you post product reviews on your blog, you may have to answer to the...
2009-10-07
556 reads
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-10-05
4,542 reads
If you are in the Dallas/Ft. Worth area and are interested in SQL Server developer training, there is an opportunity...
2009-10-02
640 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