The Power of Data and Privacy
Steve discusses privacy and data that is publicly available on the Internet.
2026-02-11
85 reads
Data Privacy and Protection
Concerns over AI Chat Privacy
Many of the GenAI services are using the free model of the past, where they use your data in ways you might not expect. Now, a court is ensuring OpenAI keeps your chat data around.
2025-09-03
103 reads
2024-09-16
89 reads
A Lack of Privacy in Smart Cars
With new vehicles becoming more and more computerized and controlled, is data privacy an issue?
2023-11-29
185 reads
The Chief Data Officer
The idea of a Chief Data Officer is growing in many companies. Steve thinks this is a good thing.
2022-03-16
145 reads
Location Data Is Not Anonymous
The world of public data is scary for Steve, even when the data is aggregated. It appears that keeping information private is becoming harder, and perhaps, impossible.
2021-10-04
157 reads
Tracking, Privacy, and Lots of Data
Apple has implemented some privacy controls for customers, which some advertisers don't like, but Steve agrees with.
2021-06-16
135 reads
Agree or Lose Features
Forcing users to agree to a new EULA or removing features seems like a bad idea to Steve.
2021-05-26
164 reads
Differential Privacy
Steve looks at a technique that some think will allow more data to be used in research and training.
2021-05-24
112 reads
Finding Legal Data
Using data scraped from the web might be convenient, but is it legal. Perhaps more importantly, is it moral? Steve has a few thoughts.
2021-04-19
177 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