The Computing Revolution
Steve reflects on some of the ideas of how Microsoft imagines the future of computing.
2020-07-27
144 reads
Microsoft
2020-07-06
141 reads
The Build Book of News
Every year Microsoft has held the Build conference for developers. I've been lucky enough to go a few times, and I was hoping to get the chance to attend again. With the pandemic, the entire event went virtual, and was held across 48 continuous hours. I was slightly disappointed as a few sessions I wanted […]
2020-05-23
107 reads
Is 100% Security Possible?
A security breach at Microsoft is disconcerting, especially when they don't share details.
2020-03-05
290 reads
Azure Sphere
The Azure Sphere project is a great piece of research at Microsoft that might help us data professionals with security.
2019-11-25
211 reads
2019-11-11
346 reads
A Mindset Shift
Microsoft has grown and changed their culture in the last few years, which greatly impresses Steve.
2019-11-01
315 reads
Evergreen SQL Server
Microsoft talks about evergreen SQL, where you never need to patch your database.
2025-05-14 (first published: 2019-07-24)
1,591 reads
DevOps and OSS Can Scale
Microsoft has embraced open source software, and has opened much of their code. They have also proven that DevOps development can scale in this environment.
2019-07-17
205 reads
More Linux than Windows
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
2025-05-26 (first published: 2019-07-06)
350 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
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