Does It Help
This editorial was originally published on Oct 12, 2006, published today as Steve is out today at the PASS Summit. Today Steve talks about the productivity that comes from having multiple monitors.
2011-10-14
100 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
The Contest That's Out of the World
Steve Jones talks about the most interesting contest, evah! Brought to you by Red Gate Software.
2011-10-13
101 reads
2011-10-13
2,098 reads
Practicing for DR
One of the sayings that I’ve heard a few times from professional atheletics is this:
“Amateurs practice until they get it...
2011-10-12
811 reads
SQL Run was awesome
When Jes Borland suggested we do a group SQL Run in Seattle, I was thinking that we’d have a few...
2011-10-12
1,628 reads
The Countdown
Steve Jones has a short piece today, about an announcement coming today at 10am PST during the PASS Summit.
2011-10-12
142 reads
The Half Day Experiment
A change at the PASS Summit this year has Steve Jones watching to see if it works out well for attendees and speakers.
2011-10-11
71 reads
A Nice Refund
This editorial was originally published on Sept 12, 2006. The IRS makes a $318mm mistake and Steve talks about the need to ensure that you don't do something similar.
2011-10-10
147 reads
2011-10-10
109 reads
The DR Test Schedule
Planning for disaster recovery entails a lot of different items, but testing is an important one. If you don't test your plans, you can't be sure they will work. This Friday Steve Jones asks how often your test.
2011-10-07
194 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