Just Deserts
Here’s another photo from my phone, this one from SQLSaturday Tampa in the cafeteria area. An easy typo to make,...
2011-06-02
604 reads
Here’s another photo from my phone, this one from SQLSaturday Tampa in the cafeteria area. An easy typo to make,...
2011-06-02
604 reads
Recently I was participating in a round of storage rearranging with a client (aka the storage dance) which consisted of...
2011-05-31
1,554 reads
It’s that time of year again, actually a little earlier than in previous years as we’ll be holding our fifth...
2011-05-31
1,498 reads
One of the benefits of experience is that you can see problems coming, that doesn’t mean you have enough experience...
2011-05-26
733 reads
It’s been almost two weeks since we wrapped up our first SQLRally, and in some ways it hasn’t quite sunk...
2011-05-25
649 reads
A few weeks back I was on a short trip with my family and as some trips go, it had...
2011-05-23
674 reads
Today we have a guest editorial from Andy Warren. Andy talks about your annual review and how you might want to think about negotiating for a raise in advance.
2011-05-23
196 reads
Just in case you didn’t catch the news yesterday on Twitter, the PASS blog, or via the PASS Connector, we...
2011-05-19
692 reads
Today we have a guest editorial from Andy Warren. Most people get an annual review that determines what their salary change might be for the next year. Does 3% make a difference? Andy Warren asks the question today.
2011-05-19
270 reads
With all the talk about SQLRally Orlando you may have missed that we’ve got another SQLRally event in the pipeline...
2011-05-17
686 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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