Fourth of July Bloopers
Here you go. The raw ones.
It’s a holiday, and usually I’m spending time with the family and enjoying the...
2012-07-04
1,110 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
2012-07-04
79 reads
2012-07-04
3,467 reads
Fix Failures Fast
A new study from Microsoft Research looks at failures in PCs. Steve Jones thinks there are a few things worth talking about for DBAs.
2012-07-03
142 reads
Colorado Wildfires
More than a few people have asked how I’m doing with all the fires in Colorado, so I wanted to...
2012-07-02
981 reads
Security and Honesty
Today Steve Jones talks security and the need for us to share information about issues, especially those that impact security.
2012-07-02
144 reads
2012-07-02
330 reads
2012-07-02
2,852 reads
The High Availability Poll
Most customers and clients wants highly available systems, with 100% uptime if possible. However most don't want to pay for them, and eventually tolerate some outages to keep costs down. This Friday, Steve Jones asks what is your environment like.
2012-06-29
154 reads
Password Help
Passwords control most of our access to computer systems and provide some level of authentication, but their security depends heavily on their strength and privacy. Steve Jones says you can set a good example for others and hemp improve security on all systems.
2012-06-28
227 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