The Secure Medical Data Challenge
This week Steve looks at the challenges of security for medical data.
2017-02-27
87 reads
Editorial
2022-12-26 (first published: 2017-02-24)
203 reads
The Cloud is Just a Tool
Today Steve Jones argues the cloud is just another tool for us to use. Not required, not ignored, but considered.
2017-02-23
116 reads
2017-02-20
113 reads
Approaching Politics in IT
The news cycle seems to be dominated by discussion of politics. Regardless of where you fall on the political spectrum, the talk of politics is inescapable and is probably going to lead to you being displeased with your fellow man. Luckily, we work in IT, so we can avoid politics. BWA-HA-HA-HA-HA! Politics goes way beyond […]
2017-02-20
126 reads
What motivates you to do your best?
In today's guest editorial: the motivation to do our best must come from within.
2023-04-07 (first published: 2017-02-17)
203 reads
2017-02-16
115 reads
What Would You Do if Your Company Was Targeted?
Today we have a guest editorial that asks what you might do if you knew a hacker was coming after your organization.
2017-02-15
119 reads
Quality Provides Traction/Velocity
Quality is a driver for productivity. Or so say I. What do you think.
2017-02-14
94 reads
Problems With Database Problems
The GitLab crisis has Steve Jones thinking about two things: competence and care.
2017-02-13
119 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
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 *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers