Kalen Delaney’s Weekly Webinars
Anyone who has been working with SQL Server for any length of time should be aware of the name Kalen...
2017-12-07
340 reads
Databases – Infrastructure – Security
Webinar: Understanding SQL Injection and Its Consequences
On Thursday, December 14, at 3 PM Eastern, I will be giving a presentation on SQL injection. Registration is required...
2017-12-06
472 reads
More Beginner / Fundamentals Content
Not surprisingly, there are folks who want beginner / fundamentals presentations and blog posts.
I put up the poll based on a...
2017-12-22 (first published: 2017-12-05)
1,896 reads
Security Architecture: Knowing the Adversary
When I present or teach on a security topic, I take the time to cover the mindset of the adversary....
2017-12-13 (first published: 2017-12-04)
1,740 reads
Geek Sync Recording: Taking Control of Your SQL Server Sprawl
Back in July, I gave a webcast for Idera’s Geek Sync. They’ve published the recording. You can find it here:
Take...
2017-11-17
446 reads
Learning to Give Presentations Well (Part 2)
Presentation Zen cover
In Part 1, I gave some advice from Toastmasters. We’ll return to the Toastmasters advice in Part 3....
2017-11-15
529 reads
Learning to Give Presentations Well (Part 1)
I’ve given technical presentations for years. I’ve also taught in churches and youth groups years before that. For me, speaking...
2017-11-17 (first published: 2017-11-06)
1,510 reads
If You’re Stuck at Home for the PASS Summit
Conferences are a great place to network, to see new technologies or to see existing technologies being used in new...
2017-10-30
674 reads
Don’t “Test” Against Production
A few months ago, I was participating in a threat hunting exercise on the security side. The gentleman leading the...
2017-10-30 (first published: 2017-10-18)
2,062 reads
Automating Everything with PowerShell – Getting Started #tsql2sday
I try to automate everything I can with PowerShell. Whether we’re talking SQL Server, WSUS, Active Directory, or any other...
2017-10-17
907 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
VS Code, Unresolved References.
Hi all, I just started using VS Code to work with DB projects. I...
Fun with JSON II
Comments posted to this topic are about the item Fun with JSON II
Changing Data Types
Comments posted to this topic are about the item Changing Data Types
Question of the Day
Fun with JSON II
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 t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers