Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]
2019-06-15
212 reads
2019-06-14 (first published: 2015-05-19)
596 reads
This week Steve Jones wonders if we work too much. Do we give more to our employers than they give to us?
2019-06-11 (first published: 2015-12-18)
1,041 reads
Kathi Kellenberger discusses the challenge of deciding how to describe the content in the sessions she presents.
2019-06-10
374 reads
One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]
2019-06-08
229 reads
We have got a deal for you, Microsoft is concerned about the health of your company and is doing something about it.
2019-06-07 (first published: 2015-04-27)
1,107 reads
There are a couple big changes that the cloud brings to us. Steve has a few comments today.
2019-06-06
432 reads
Comments in code can be tricky, but certainly some are better than others. What are your bad examples?
2019-06-05 (first published: 2015-03-13)
657 reads
This Friday's poll looks at the time after deployment. Can you tell if things were successful? Do you have a formal way to determine if the changes are causing issues?
2019-06-04 (first published: 2015-04-17)
372 reads
Just as you write a unit test before writing the code, so you must devise the means to monitor a database, to ensure its smooth operation, before creating the database.
2019-06-01
218 reads
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,...
Quite the title, so let me set the stage first. You have an Azure...
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