Powershell Saturday in Tampa on March 19th, 2016
I was interested/intrigued to see that we’ll have a Powershell Saturday on March 19th in Tampa. This will be the...
2016-01-05
617 reads
I was interested/intrigued to see that we’ll have a Powershell Saturday on March 19th in Tampa. This will be the...
2016-01-05
617 reads
Over the past couple of days I’ve posted several times about the Advent of Code Contest and worked my way through...
2015-12-24
715 reads
This one gives you a 1000 rows of package dimensions. You calculate the surface area needed for wrapping paper, plus...
2015-12-23
668 reads
Part 1 isn’t bad. Parse a string that has direction indicators and track each location you stop at. I’m trying...
2015-12-23
973 reads
Adding to my solution for #3 part 2, I finally got it, but I paid the price for not adding...
2015-12-23
694 reads
I just donated $10 to Wikipedia. I use it and find it useful, so I don’t mind contributing so that...
2015-12-22
565 reads
It’s the ‘get your flu shot’ time of the year, which is also a good time to review your immunizations....
2015-12-22
639 reads
Today we have a guest editorial from Andy Warren. We still have many applications runnning under sysadmin accounts, often "sa". Why do people do this? Andy has a few thoughts on the subject.
2015-12-21 (first published: 2011-05-04)
527 reads
Sometime in the next couple weeks Rodney & Karla Landrum are moving from Orlando to Pensacola (home). I’m happy for them...
2015-12-21
621 reads
I saw the post from Steve Jones about the Advent of Code contest and decided to take a look. The first...
2015-12-18
653 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