Opening Doors – Part 1
As a speaker, blogger, even a DBA at work it’s hard to know when you’re having a positive impact on...
2009-11-23
722 reads
As a speaker, blogger, even a DBA at work it’s hard to know when you’re having a positive impact on...
2009-11-23
722 reads
Yesterday in Part 1 I wrote about opening doors – the art of showing others what is possible within the context...
2009-11-23
535 reads
I read The Deceived a few weeks back and enjoyed it, even though it was the 2nd book in the...
2009-11-19
499 reads
I’ve had this on my list of things to talk about someday, a recent post on almost the same subject...
2009-11-18
599 reads
In a recent blog post Brent Ozar questioned why PASS decided to relaunch the SQL Server Standard given the failure...
2009-11-17
747 reads
Last Monday was my first day back from the PASS Summit, planned for (and was) a slow day, just starting...
2009-11-16
497 reads
New friend David Easley shared two sources for hot sauce that I wasn’t familiar with:
http://www.datilsensation.com/products.shtmlhttp://www.pepperpalace.com/I like some spice here and...
2009-11-15
528 reads
I grew up watching baseball on TV and playing it too, and for reasons I don’t recall my Dad’s favorite...
2009-11-12
538 reads
A few weeks ago I was looking for a few branded items, happened to run across drink coasters at 4imprint....
2009-11-11
582 reads
I’m sure you know what I mean when I say that I feel like my ability to task switch and...
2009-11-11
480 reads
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
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,...
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