Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands ISACA Chapter partner together to put on a "CPE catchup" opportunity in December to provide...
2025-12-17
16 reads
In parallel with the presentation I gave at the PASS Data Community Summit on quantum computing's impact on data, I wrote an article specifically on impact with respect to...
2025-12-17 (first published: 2025-12-03)
233 reads
Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote that instantly stood out as my favorite of the day “Is it possible? …..Why not!...
2025-12-17 (first published: 2025-12-03)
124 reads
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is Ireland’s free, community led, Microsoft Data Platform event. We had a fantastic event this year...
2025-12-16
62 reads
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you might have hit a wall trying to get it running. Here’s what happened when I...
2025-12-15 (first published: 2025-11-26)
901 reads
Each year around this time, companies enter the familiar ritual of budgeting. For many, it feels like a long and exhausting negotiation between ambition and constraint. Everyone knows, it...
2025-12-15 (first published: 2025-12-02)
704 reads
Superheroes and saints never make art. Only imperfect beings can make art because art begins in what is broken – from Excellent Advice for Living Interesting advice for living...
2025-12-12
12 reads
Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day to connect with new faces, explore the bustling expo hall, engage with customers and service...
2025-12-12 (first published: 2025-12-02)
282 reads
Following on from my last post about Getting Started With KubeVirt & SQL Server, in this post I want to see if I can improve the performance from the...
2025-12-11
86 reads
Dry-run xp_delete_file Before Actually Deleting Files?
xp_delete_file doesn’t really have a built-in dry-run option to preview which files it would remove. But there’s a simple workaround,...
2025-12-10 (first published: 2025-11-27)
467 reads
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
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