GIT Learning Resources
I’ve spent most of my career using VSS and TFS, mainly because that’s what was being used. Better any source...
2016-07-15
428 reads
I’ve spent most of my career using VSS and TFS, mainly because that’s what was being used. Better any source...
2016-07-15
428 reads
Strangely enough its been a long time since I installed SQL in production. It’s almost always done by someone on...
2016-06-27
1,209 reads
I hope when you’ve read all of this post that you’ll think that I’ve added to the discussion and not...
2016-06-24 (first published: 2016-06-20)
1,216 reads
Can you guess what all of these people have in common?
Shawn WeisfeldJoe HealyBarry RalstonTrey JohnsonJon WinerWes DumeyDonnie ReynoldsKevin JacobsJoseph MemmoBrian...
2016-06-22
483 reads
Today PASS released a bunch of stuff for the upcoming election including the attributes of an “ideal candidate”. We put...
2016-06-22
418 reads
We’ve advanced the closing date for the SQLSaturday Orlando call for speakers to July 17. That’s to give us time...
2016-06-22
394 reads
Just glanced through the MCP newsletter and see that the price of the exams (or at least the one I...
2016-06-14 (first published: 2016-06-09)
2,647 reads
Today we have a guest editorial from Andy Warren that looks at the decision to leave a job. Or not.
2016-05-26
157 reads
This year I’ll blog sporadically on the event, focusing on pain points, discoveries, and new ideas with the occasional progress...
2016-05-23
421 reads
I was talking a bit with a friend at SQLSaturday Jacksonville and realized I needed to write down a thought...
2016-05-09
1,129 reads
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)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
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