Starting Conversations - Part 2
A week or so ago I posted a note about reading How to Start a Conversation and Make Friends (worth...
2009-04-15
380 reads
A week or so ago I posted a note about reading How to Start a Conversation and Make Friends (worth...
2009-04-15
380 reads
I happen to notice this in a class recently that I had the rare student - one that could take notes...
2009-04-14
393 reads
I've been writing a lot about networking lately and my efforts to learn/leverage LinkedIn, and along the way taken a...
2009-04-13
824 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-13
290 reads
Time has flown by since my last update, busy time at work and struggling to get that done and find...
2009-04-13
389 reads
As I've covered in my two earlier posts I've been investing a little time to figure out how to make LinkedIn work for me. This time I wanted to talk about some extra tools they provide that you may find useful. One that I mentioned previously...
2009-04-13
3,192 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-12
303 reads
Back in December 2008 I wrote up a quick review of Red Thunder, and then received Red Lightning as a...
2009-04-09
284 reads
Please consider this a not quite official announcement, look for that on the sqlpass.org site today or tomorrow.
You may have...
2009-04-09
1,211 reads
The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.
2009-04-09
2,674 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