LinkedIn is full of absolute trash these days. Just flat out b****** garbage. (Oh yeah, that – this post should probably come with a language disclaimer, because this stuff makes me mad.)
2026-03-16
Supervised training of an artificial neural network entails training the network to associate defined patterns with specified labels. Optical Character Recognition is an example of supervised training, where each input pattern is mapped to an alphanumeric character. In unsupervised training, a neural network learns to extract recurring patterns from noisy data. One of the earliest […]
2026-03-06
1,061 reads
Introduction. Why AI Readiness Starts in the Database You probably don’t need machine learning today. Most organizations don’t. You already have reporting dashboards, operational workflows, and business intelligence that work just fine without neural networks or predictive models. That’s not a failure. It’s normal. The problem doesn’t show up immediately. It shows up a few […]
2026-02-27
2,013 reads
2026-02-25
82 reads
As Steve uses AI more, it seems determinism isn't something you get out of many LLMs.
2026-02-23
104 reads
Adding non-core database features to a system can expand its capabilities, but it can also be an expensive use of your hardware and software licenses.
2026-02-04
89 reads
This seems like the appropriate first BrentOzar.com blog post in the year 2026, eh?
2026-02-02
GenAI technology is going to change coding, but there is still a lot of work available for humans.
2026-01-26
87 reads
When I was at the Small Data 2025 conference, one of the speakers was talking about their work with AI technologies. This person uses it a lot in their day job, often to complete tasks that they would have struggled to work on in the past, mostly because of time constraints, but also a lack […]
2026-01-16
162 reads
Learn how we can search text values in SQL Server 2025 using the new AI capabilities.
2026-01-12
3,273 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