Thinking About the 2021 PASS Summit
I know that we don’t yet know how the 2020 Summit will turn out, but I’ll make some guesses: A lot of people like it for the lower cost,...
2020-08-18 (first published: 2020-08-05)
741 reads
I know that we don’t yet know how the 2020 Summit will turn out, but I’ll make some guesses: A lot of people like it for the lower cost,...
2020-08-18 (first published: 2020-08-05)
741 reads
Some thoughts on the PASS Virtual Summit this year: Clearly the in-person option wasn’t doable. Just too hard to know infection rate, local rules, employer travel guidelines, attendee and...
2020-07-31 (first published: 2020-07-17)
219 reads
I’m sure it’s no surprise, but we’ve decided to cancel SQLSaturday Orlando 2020. We decided a couple weeks ago but it’s been tough to summon the energy to write...
2020-07-17
89 reads
Today we have a guest editorial from Andy Warren that looks at digging deeper into stereotypes and deeper learning.
2020-07-03 (first published: 2016-02-19)
229 reads
A few years ago I had a requirement to allow both developers and customers to see rows from a table used to store error information while making sure that any PII, PCI or similar sensitive data was not displayed. The tolerance for “oops” was low! This article presents one way to solve the challenge by […]
2020-04-27
1,764 reads
I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write them down to at least be able to look back at them once the storm...
2020-04-04
148 reads
We’ve cancelled our upcoming Meetups in April and May due the loss of our venue (due to corona virus worries) though we would have probably cancelled them anyway. Our...
2020-03-16
7 reads
The notes! Attendance was the speaker dinner was great! Always nice to have a lot of people there. During the day logistics all went well, though it’s still a...
2020-03-08
26 reads
One the things I’ve been doing over the last year is sending out a monthly reminder email of upcoming events. Not revolutionary, I know. I’m sharing what we do...
2020-01-30 (first published: 2020-01-22)
160 reads
Code Camp will be March 28th, 2020 at Seminole State College. The fifteenth consecutive year! They are definitely interested in developer/end user SQL content and would like at least...
2020-01-07
40 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