Web Site Tuning
I just spent a couple days doing some minor tuning on SQLShare and here are some notes from that effort.
I...
2010-01-25
603 reads
I just spent a couple days doing some minor tuning on SQLShare and here are some notes from that effort.
I...
2010-01-25
603 reads
I read Life and Death on the World’s Most Dangerous Mountain by Ed Viesturs ($18 @ Amazon) over the holiday break....
2010-01-22
735 reads
I’ve had to cancel my plans to attend, which also included plans for a late lunch at the Green Iguana...
2010-01-22
537 reads
Just prior to the 2009 PASS Summit I posted about giving Twitter a try, and thought I’d report back on...
2010-01-21
2,190 reads
Recently I caught a few minutes of a CSPAN interview with Chief Justice John Roberts, part of a larger presentation...
2010-01-20
490 reads
Somehow had completely missed this one, The Architectural Journal is published quarterly in PDF format. Issue 22 seems to be...
2010-01-20
542 reads
I’ve been thinking a lot lately about how to be more effective at collaborating, usually in the context of a...
2010-01-19
680 reads
Today we have a guest editorial from Andy Warren. We all would love to have perfect code, but is always worth the time? Andy Warren notes that cutting a corner or two might make sense at times.
2010-01-19
155 reads
Before you dig in this post, take a look at my earlier notes about oPASS and Live Meeting and the...
2010-01-18
760 reads
I read a lot and like to think my interests are wide, but I fall into ruts all the same....
2010-01-15
530 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