2015-12-15
207 reads
Editorial
Security Decisions
This week Steve Jones looks at how we make secutiy decisions for our systems, and whether this is really the best way to do things.
2015-12-14
100 reads
2015-12-14
311 reads
How Much Eventual Consistency Do You Have?
This week Steve Jones wants to know if you have eventual consistency in your environment?
2015-12-11
248 reads
Are We Engineers?
Steve Jones continues the never ending argument of whether software developers deserve the moniker of engineer.
2015-12-10
173 reads
2015-12-09
120 reads
IT Data Governance and the Insider Job
Good IT data governance is about crime-prevention as well as crime-detection. Legal action runs war a close second as being one of the more futile and debilitating of human activities, so prevention is always better.
2015-12-07
116 reads
Gratitude
Today we have a guest editorial from Erin Stellato that reminds us that we have had support from many, and it's important to thank them from time to time.
2015-12-04
140 reads
What is DevOps?
The DevOps moniker seems to bring together good practices that some companies have followed for years. However lots don't, and today Steve Jones tries to get inspire a few of you to give it a try.
2015-12-03
218 reads
Rethinking Hiring
Today Steve Jones looks at the problems we have with hiring staff and the troubles we go through. Perhaps we can do better with an investment in our people.
2015-12-02
171 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