2019-12-25
76 reads
Editorials
Double Check Your Math
Steve notes that math operations are places where many developers have made mistakes in the past. A little test code might help here.
2019-12-23
308 reads
Learn to Change
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
167 reads
Server Hardware or Coffee?
Today Steve Jones looks at the relative cost of hardware and how we sometimes cause ourselves issues by not spending enough.
2019-12-20 (first published: 2016-11-03)
270 reads
2019-12-18
256 reads
Better Protection from Hardware
Today Steve looks at a research project from Microsoft that provides some better protection from firmware security issues.
2019-12-17
160 reads
The harsh reality of charitable IT work
At work in IT, we can wander around looking important with no apparent useful skills whatsoever. When working outside the bubble of the industry, things are different.
2019-12-14
267 reads
A New Recovery Tool for Your Toolbelt
Learning a new skill is always helpful, especially for backup and restore. Steve Jones talks about an idea from the SQLCAT team.
2019-12-13 (first published: 2016-11-15)
342 reads
2019-12-12 (first published: 2016-11-14)
476 reads
Product Platform Teams
Today Steve notes that DevOps isn't going to eliminate Ops, even if developers support their own applications.
2019-12-10
123 reads
Blogs
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,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Foreign Keys - Foes or Friend?
Comments posted to this topic are about the item Foreign Keys - Foes or...
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