2019-07-26 (first published: 2015-08-28)
571 reads
Editorial
NOSQL and RDBMSs
NOSQL and RDBMS are evolving and absorbing ideas from each other. Is this necessarily a good thing? Perhaps we should think again
2024-06-14 (first published: 2015-08-27)
868 reads
A Clock With Benefits
Explaining how computers work can be hard for technical people, but it's important for us to help our clients, customers, and managers appreciate why building new software is hard.
2019-07-25 (first published: 2015-08-26)
378 reads
2019-09-03 (first published: 2015-08-25)
270 reads
Why Use Version Control?
Steve Jones has a story about what it's like to work with, and without, Version Control Systems.
2015-08-24
173 reads
Annual Security Compliance Training
A guest editorial from Andy Warren that looks at annual training to try and improve security.
2023-03-17 (first published: 2015-08-21)
192 reads
2015-08-20
180 reads
Your Portfolio
Putting together a portfolio allows you the chance to showcase what you're good at doing. Steve Jones thinks this might be a good thing for technical people.
2015-08-18
137 reads
Mission Critical Deployments
Is a software deployment responsible for a plane crash? That's a scary thought.
2015-08-17
120 reads
Nope to NoOps, No way to NoDBA
Phil Factor suspect the NoOps movement is dressing up some old mistakes in fancy new clothes.
2015-08-17
258 reads
Blogs
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Forums
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
Ready to launch your next big game?
Looking for a creative and experienced mobile game development company that brings your game...
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