Can You Dig It? – Plan Cache Series
She can dig it!
D Sharon PruittA few PASS Summit’s ago, I became interested in the information available in the...
2011-02-18
578 reads
StrateSQL
Writing A Month Long Blog Series
You might wake up one day soon and think, “Hey, wouldn’t it be cool to write a month long blog...
2011-02-14
604 reads
CHD Awareness Week
Do you know about congenital heard defects (CHD)? Did you know that February 7-14 is the week dedicated to making...
2011-02-14
470 reads
February PASSMN Meeting This Week
PASSMN meeting is this week on Tuesday. Without further ado…
Meeting Details
Here are the details on the meeting location and time:
Date:February...
2011-02-14
527 reads
Can You Dig It? – Find Estimated Cost
She can dig it!
D Sharon PruittIt’s the eighth post in the plan cache series. I hadn’t expect to take as...
2011-02-11
895 reads
Iowa PASS Presentation Materials
Driving to the User Group
This past Wednesday I took a drive down to the Iowa SQL Server Users Group meeting. ...
2011-02-11
472 reads
31 Days of SSIS Conclusion
31 Days of SSIS
Last month, I published the 31 Days of SSIS blog series. As a conclusion to that series,...
2011-02-10
771 reads
SQL Server MVP Daily Paper
A while back, I started a twitterlist of SQL Server MVPs. I wasn’t really sure why, but I just thought...
2011-02-10
544 reads
February PASSMN Meeting Announced
If you are looking for a change to get together with other SQL Sever professionals in February to talk about...
2011-02-07
710 reads
PowerShell: Download List of SQL Server MVPs
Turtle Shell?!
This weekend, I was working on something that I will blog about later this week. As part of that,...
2011-02-07
749 reads
Blogs
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...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Forums
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Foreign Keys - Foes or Friend?
Comments posted to this topic are about the item Foreign Keys - Foes or...
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