I read this great little blog post called "Trying to Notice What's Missing." It's not real long and it's worth your time. If you'd like a TLDR, the author points out how in-person meetings at conferences resulted in enhancements to open source software due to superior, in-person, communication. Strictly on a personal level, I miss […]
2021-04-17
144 reads
I've always been fascinated by history. For a long time growing up, my plan was to become a history teacher. While that didn't work out, I've continued to read quite a lot of history, both popular and scholarly works. One of the things about it that I find most fascinating are the stories. History is […]
2021-03-06
47 reads
Many of us grew up with one version of Cinderella or another. The step child that's horribly mistreated by the new parent is a scary story. In the Disney version, everything works out fine. However, if you read some of the original Grimm versions of the story (and there is more than one version), not […]
2021-01-30
64 reads
As I type this, I've got my right leg propped up on a stool. That's because if I sit for any length of time with the knee bent, I have a great deal of pain on standing. Seems there's something horribly wrong with my knee. I still don't know what yet. I've had an MRI […]
2021-01-09
63 reads
2020-12-19
97 reads
An organization, or an event, is more than just the name and structure. It's mostly the people.
2020-11-21
174 reads
The term DevOps gets horribly abused. Don’t get me started on all the weird additions to it like DevSecOps. No, I just mean the term itself gets beaten up quite a lot. It’s to the point where people are starting to shy away from talking about it. I’ve even changed my approach when discussing DevOps […]
2020-10-24
167 reads
Today we have a guest editorial as Steve is out of town at the PASS Summit. Grant looks at disasters and being prepared.
2020-10-20 (first published: 2016-10-24)
236 reads
I'm learning how to be a net controller for a high frequency (HF) radio network. Nets are a fun way to make lots of contacts quickly. Taking part in a net is simple. You check in with the net control and then you can answer calls or make calls (different nets have different rules). It's […]
2020-09-26
90 reads
Today we have a guest editorial where Grant talks about being effective and practical in your world.
2020-09-17
167 reads
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Hi all, I just started using VS Code to work with DB projects. I...
Comments posted to this topic are about the item Fun with JSON II
Comments posted to this topic are about the item Changing Data Types
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