There was an interesting article about how telecommuting is the secret to employee happiness and it makes some sense in today's fast-paced, highly connected world. There are a number of job surveys that list flexible hours as one of the most desired benefits.
2012-10-05 (first published: 2007-10-10)
871 reads
Does it make more sense for a company to build it's own software or buy a package?
2012-10-04 (first published: 2007-10-23)
216 reads
2012-10-04
2,154 reads
Should you dog food your own software? Steve Jones thinks this is a good idea if it works for your particular product.
2012-10-03 (first published: 2007-09-28)
640 reads
There's still hope for all you DBAs out there looking for a telecommuting job that allows you to work in your pajamas. Someone sent me this case study about remote DBAs and I decided to pass it along. It's a one page PDF, and it's a fluff piece to some extent for Bluewolf, a company that has outsourced IT staffing, but has a section on remote DBA work as well
2012-10-02 (first published: 2007-09-19)
1,371 reads
Challenge yourself to find new tools and use them in your work. That's today's message from Steve Jones. (This editorial was originally published on Aug 5, 2007. It is being re-run as Steve is away on the SQL in the City US 2012 tour.)
2012-10-01
305 reads
I told people in New York at SQL in the City that I’d post some resources on the blog from...
2012-10-01
1,283 reads
That’s where we were on Friday. 780 Third Avenue, in the middle of Manhattan. The start of our 2012 US...
2012-10-01
1,195 reads
I’ve been working on a new presentation for full text search and brushing up on some of my T-SQL operators....
2012-09-27
4,824 reads
“New York City…center of the universe..” – Rent
I’m off to New York this morning for the start of the 2012 SQL...
2012-09-27
1,694 reads
By HeyMo0sh
Over time, I’ve realised that one of the hardest parts of cloud management isn’t...
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
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
Comments posted to this topic are about the item Answering Questions On Dropped Columns
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