SQLSaturday Doesn’t Have to Be a Platform
When we built the first SQLSaturday it was about 2 pages of HTML. No login, no tools, just get it done. Worked ok. Didn’t work so well for the...
2021-01-21 (first published: 2021-01-14)
268 reads
When we built the first SQLSaturday it was about 2 pages of HTML. No login, no tools, just get it done. Worked ok. Didn’t work so well for the...
2021-01-21 (first published: 2021-01-14)
268 reads
in my last post I wrote about thinking of the tools as being a separate thing from the event. Not a complicated concept, but does it matter? Maybe. Let...
2021-01-16
6 reads
I think our profession was the better for having a professional association, even if it never quite did as much as I wanted it to. I put a lot...
2021-01-16
178 reads
I think our profession was the better for having a professional association, even if it never quite did as much as I wanted it to. I put a lot...
2021-01-16
5 reads
Not easy to say, Gareth passed away a few days ago. We’d both gotten busy and with Covid added in, we had not caught up in a while. Now,...
2021-01-14
623 reads
Not easy to say, Gareth passed away a few days ago. We’d both gotten busy and with Covid added in, we had not caught up in a while. Now,...
2021-01-14
4 reads
When we built the first SQLSaturday it was about 2 pages of HTML. No login, no tools, just get it done. Worked ok. Didn’t work so well for the...
2021-01-14
8 reads
As a Florida corporation we have to file an annual report. Sounds complicated, but for us it’s a five minute task. Here’s the Trello card for the work I...
2021-01-10
24 reads
As a Florida corporation we have to file an annual report. Sounds complicated, but for us it’s a five minute task. Here’s the Trello card for the work I...
2021-01-10
3 reads
Similar to my earlier post on filing the annual report, once a year we have to file a tax return with the IRS. Basically if the revenue is less...
2021-01-10
27 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