The Microsoft SQL Year in Review
Microsoft gives a year in review from the SQL Server and Azure SQL teams. Steve sees a lot of accomplishments from this past year.
2025-12-20
83 reads
Microsoft
50 Years of Microsoft
Steve looks back at his history with Microsoft and asks what your memories are of using their products.
2025-04-25
111 reads
Microsoft SQL announcements at PASS Data Community Summit 2024
Read a summary of the data platform announcements from Microsoft at the PASS Data Community Summit 2024 last week.
2024-11-18
1,003 reads
Do You Want a Microsoft Solution?
Today Steve wonders if official solutions from a vendor are that important.
2024-11-15
116 reads
2024-11-06
199 reads
Microsoft at the PASS Data Community Summit 2024
Learn about the Microsoft sessions at the 2024 PASS Data Community Summit from Bob Ward.
2024-10-28
171 reads
Microsoft return to PASS Summit 2024 as Sapphire sponsor
Get ready to meet Microsoft's experts on-site in the exhibit hall and in multiple educational sessions (including a pre-con, keynote and learning pathway). Watch a sneak peek of Microsoft's learning pathway 'Becoming an Azure SQL DBA – Advancing the Role of the On-Premises SQL Server DBA'
2024-09-18
Microsoft at the PASS Data Community Summit 2023
Microsoft will be presenting a number of sessions at the PASS Data Community Summit 2023. Read about their plans for the event and register to come if you can.
2024-05-14 (first published: 2023-11-03)
307 reads
AI Thoughts on the Build Keynote
Today Steve has a few thoughts, and links, from the Build Keynote last week, which featured AI technology.
2023-05-26
158 reads
2023-04-29
137 reads
Blogs
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
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...
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