Notes on the Jacksonville Code Camp 2009
I'm a couple weeks last posting this, but wanted to get my notes down anyway for future use. The goal of...
2008-09-09
465 reads
I'm a couple weeks last posting this, but wanted to get my notes down anyway for future use. The goal of...
2008-09-09
465 reads
I'll define a brown bag lunch as a training event held at lunch time where someone on the team does...
2008-09-08
1,100 reads
Sorry, I couldn't help not including 'Book Review' on the subject line, hopefully you're not too disappointed!
I just finished reading...
2008-09-07
357 reads
Renaming Databases was just published on SSC, another in my lastest effort to expose some of the hidden complexities in seemingly...
2008-09-04
295 reads
If all has gone well I've been on vacation this week, enjoying the world class quartz sand at Siesta Key...
2008-09-04
1,110 reads
I do very little consulting these days, perhaps 4-5 weeks per year, and that only to make sure I maintain...
2008-09-03
295 reads
Creating Databases was actually posted last week, but got distracted with some other stuff. A basis walk through of creating...
2008-09-02
398 reads
Expert trainer and longtime DBA, Andy Warren, tackles the rather simple, but often understood, process of renaming a database. Learn about some of the issues you might encounter when trying to complete this task.
2008-09-02
9,701 reads
When I teach my introductory (and free) Successful Technical Speaking class to try to help beginners enter the world of speaking,...
2008-09-01
407 reads
It's Labor Day here in the US today, a holiday that is tribute to those of us that work, the journey to...
2008-08-31
1,773 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