Over the years, I’ll admit, SQL Server has come a long way in making life easier for database administrators and with each version it keeps getting better and better....
2025-09-08 (first published: 2025-08-19)
499 reads
I’m excited to announce the release of a new open-source project that fully automates HammerDB benchmarking for SQL Server using Docker. If you’ve ever needed to run TPC-C or...
2025-09-06
196 reads
Don’t reserve your kindest praise for a person until their eulogy. Tell them while they are alive when it makes a difference to them. Write it in a letter...
2025-09-05
860 reads
From where I stand, the decision between Cosmos DB and a traditional SQL database often wants to be chosen between a sports car and a reliable sedan. Both will...
2025-09-05 (first published: 2025-08-18)
654 reads
I’m in the progress of migrating some legacy stuff at a client, and in their Power BI environment there are still quite some Power BI dataflows Gen1. I had...
2025-09-05 (first published: 2025-08-20)
350 reads
As part of a demo recently I was adding a default value to a new column with a simple DEFAULT and a value. Under the covers this creates a...
2025-09-03 (first published: 2025-08-11)
466 reads
I want to talk about a fairly new product that you may not be aware of: Azure IoT Operations, which GA’d last November (it was first announced at Ignite...
2025-09-03 (first published: 2025-08-19)
780 reads
SQL Server Integration Services (SSIS) is a mature, proven tool for ETL orchestration and data movement. In recent years, Python has exploded in popularity as a data movement and...
2025-09-01 (first published: 2025-08-11)
372 reads
In a tech landscape dominated by distributed systems, serverless architectures, and real-time analytics, one might assume that SQL, a language born in the 1970s, would be fading into obscurity....
2025-09-01 (first published: 2025-08-11)
1,290 reads
Had an incredible time at DevUp in St. Louis this weekend! This conference gets better and better each year and draws in some incredible folks from all over the...
2025-08-29 (first published: 2025-08-08)
124 reads
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
hi everyone I am not sure how to write the query that will produce...
Comments posted to this topic are about the item Rollback vs. Roll Forward
Comments posted to this topic are about the item Foreign Keys - Foes or...
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