T-SQL Tuesday #36 - SQL Community (Guest Post)
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2012-11-06
638 reads
Kendal Van Dyke
2012 PASS Elections Letter Of Recommendation From Ed Watson
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
1,029 reads
2012 PASS Elections Letter Of Recommendation From Jes Borland
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
631 reads
2012 PASS Elections Letter Of Recommendation From Stacia Misner
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
652 reads
2012 PASS Elections Letter Of Recommendation From Karen Lopez
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-05
1,057 reads
2012 PASS Board of Directors Elections - It's Time To Vote!
It's time once again to vote for the 3 candidates we feel will best represent the SQL Server community with...
2012-10-03
1,190 reads
PowerShell Split-Path Bug And A Workaround
Split-Path is a cmdlet built into Windows PowerShell that returns a specific part of a path, e.g. a parent directory...
2012-09-05
2,624 reads
PASS Update #1 - January 2012 Recap
When I ran for the PASS Board of Directors last year I committed to providing a monthly update on PASS...
2012-08-07
961 reads
PASS Update #2 - February 2012 Recap
During the January board meeting we were told that attendance at the 2011 Summit exceeded expectations and as a result...
2012-08-07
625 reads
Time Flies When You're Having Fun (Déjà Vu Edition)
Writing - be it a technical language like T-SQL, C#, PowerShell, etc. or blogging - is like exercise. When you do it...
2012-08-06
1,530 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
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