There is a rippling effect from the hack on Yahoo. Those users and passwords are being used on other sites. Steve Jones reminds us that we shouldn't be sharing passwords, and we should educate our users to do the same thing.
2012-07-30
93 reads
Great DBAs collect all kinds of metrics on their instances and let them manage themselves. However many administrators need help monitoring and interpreting the data. Today Steve Jones asks if you think this data needs extra security or is it less of an issue than other PII data.
2012-07-27
368 reads
Dropbox has grown tremendously in the last few years and Steve Jones talks about a concept of running with less headroom as a way to cope with that rapid growth. Is it something you'd be interested in with a SQL Server?
2012-07-26
119 reads
A friend of mine, Erin Stellato (blog | @erinstellato) is about to change jobs. She’ll go from working in an office...
2012-07-26 (first published: 2012-07-23)
2,574 reads
Today Steve Jones talks about how you can find a really good job. And how you can make changes in your life to get you there.
2012-07-25
327 reads
This fall is the DevConnections SQL Server Connections conference in Las Vegas again. It’s at the Bellagio, setting for one...
2012-07-25
1,709 reads
Packing for SQL Saturday #144 in Sacramento, CO. Dan Hess, one of the organizers, asked me last November at the...
2012-07-25
1,198 reads
Today Steve Jones talks about the ability of cloud services to level the field when it comes to software, especially for small companies.
2012-07-24
99 reads
My home state of Colorado has been devastated by wildfires. My vacation this summer was semi-cancelled with a fire closing...
2012-07-23
1,281 reads
Today Steve Jones notes that security is improving at many web sites. It's not great, but it's improving. That's a good sign, or is it?
2012-07-23
114 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