2020-07-24
92 reads
The Lighter Side
2020-02-21
753 reads
Unreliable Data Sensors
Steve doesn't like the idea of cars using data from cameras to update a display instead of a mirror.
2019-09-30
196 reads
NASA officially orders its first segment of a lunar space station
"This time when we go to the Moon, we're actually ...
2019-05-23
2019-05-10
Pop Quiz: SQL 2000 Bug or SQL 2017 Bug?
Brent Ozar asks if you can tell if each of these SQL Server bugs is brand-new, or almost 20 years old.
2019-05-03
Massachusetts offshore wind project gets green light at roughly 8.9 cents/kWh
The Vineyard Wind project will also commit $15 million to battery development.
2019-04-24
These are the best new vehicles of the 2019 New York International Auto Show
American auto shows are in decline, but we still found a few things to excite.
2019-04-22
The Porsche Panamera Turbo Sport Turismo—to hybrid or not to hybrid?
The Panamera Turbo comes in two flavors, and the more powerful one is a hybrid.
2019-04-11
T-SQL Tuesday #113: A year of marriage and boardgames
This week’s T-SQL Tuesday is about where you use databases in your personal life. And I have a database I don’t use any more that’s a little happy and...
2019-04-09
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
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