Picking a Blog Platform
For the past couple years I’ve been using Community Server for blogging, only because that’s the platform that’s been part...
2010-01-06
1,152 reads
For the past couple years I’ve been using Community Server for blogging, only because that’s the platform that’s been part...
2010-01-06
1,152 reads
Posting goals online is great as long as you meet your goals, can be something less than great if you...
2010-01-05
800 reads
Not easy to find yet on the new site, you can find it at http://www.sqlandy.com/feed/.
2010-01-05
316 reads
Bill Graziano posted some thoughts about the merits of East Coast vs West Coast placement of the Summit. He did...
2010-01-05
369 reads
I’ve been ‘on vacation’ for two weeks and it’s been nice to relax. I wasn’t able to unplug entirely, but...
2010-01-04
457 reads
I’ve moved my blog to www.sqlandy.com and the first post of 2010 is up. It’s still very much a work...
2010-01-02
286 reads
I started blogging about 2-1/2 years ago on SQLServerCentral.com and at the time it was the logical place for hosting....
2010-01-01
325 reads
I think I’ve met my goal of blogging every day. I’m at almost 800 posts now over the past 2.5...
2009-12-30
1,400 reads
I had a student recently who said that to get any type of training she had to write a proposal...
2009-12-29
1,544 reads
Funny the things you don’t think about until you hear someone doing it a different way. In this case it...
2009-12-28
564 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