Who is the best person for the job?
Sometimes it is hard to admit that you are not the best person for the job that is presented to you.
2020-04-09
116 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
How Do You Act When You Need to Learn New Technology?
Today we have a guest editorial from Ben Kubicek as Steve is away from the office. It is hard to be humble, but it is needs to learn something new.
2019-11-27 (first published: 2016-11-07)
476 reads
Who should have Sysadmin rights?
The point of this article is that only service accounts and/or specific network sql admin accounts should have sysadmin rights.
2019-03-11
1,532 reads
2019-01-07
138 reads
2018-11-15
701 reads
The Importance of Consistent Server Setup
In larger shops with multiple database servers, it is very important to have consistency.
2018-10-12
163 reads
What is the best way to on-board (train) a new junior employee?
It is important to train new people, so what is the best way to go about doing it?
2018-09-06
366 reads
Why not take a risk and try something new?
When we risk failure, we also have the opportunity for success, so try something new today.
2018-08-30
83 reads
When someone asks you what you do for work, how do you answer?
In many ways job titles matter, just not when telling a stranger what you do for work.
2018-07-30
458 reads
How much database normalization is enough?
Normalization is important for relational databases, but sometimes too much of a good thing can be bad.
2018-07-23
2,466 reads
Blogs
Optimising Costs: Strategies for Efficient Cloud Resource Management
By HeyMo0sh
Over time, I’ve realised that one of the hardest parts of cloud management isn’t...
Cost Visibility: Tracking and Analysing Your Cloud Spend
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
Whiling away an afternoon, thinking
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
Forums
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
Answering Questions On Dropped Columns
Comments posted to this topic are about the item Answering Questions On Dropped Columns
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