Lists of Tools
I ran across this list of interesting tools by Scott Hanselman and there is some good stuff to look at...
2007-12-14
1,360 reads
Blog Posts
12000!
A short congratulations to myself. I was answering posts last night after tech editing another chapter of the book I'm...
2007-12-12
1,474 reads
Finding the relationship of a filegroup and a partition
The other day, I was trying to find out which partition is on which filegroup for a a partitioned table....
2007-12-12
1,586 reads
Driving Debate
I write a daily editorial, which is one of the reasons that I don't post here as often as I'd...
2007-12-11
1,395 reads
Managing Funds for User Groups
This question seems to come up a lot and it's worth discussing. Few user groups are incorporated, fewer still are...
2007-12-11
636 reads
Disappearance
Wow, it's been a long time since I posted here. I actually had to search for my name to find...
2007-12-10
660 reads
Podcasting
A new video setup is on the way!!!!
Actually I'll do a couple podcasts on podcasting over the holidays here since...
2007-12-10
3,046 reads
How do you make a Wiki work?
Following up on my post about Wikipedia, I read an article in Eweek, 25 Tips for a Better Wiki Deployment...
2007-12-09
634 reads
Contributing to Wikipedia
Recently I posted about an interview with Jimmy Wales and only a couple days after that I ran across What...
2007-12-06
588 reads
Tribute to Honor Jim Gray
Saw this on the Association for Computer Machinery SIGMOD announcements.
Tribute to Honor Jim Gray
It is scheduled for May 31, 2008...
2007-12-05
552 reads
Blogs
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
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