The three themes for speakers at this year's PASS Data Community Summit are: Back to Basics, Reach for the Clouds, and Level Up. The goal here is content that covers a wide variety of areas, with many fewer restrictions from previous years. Perhaps the big thing to note for this year's event is: Free. That's […]
2021-06-02
222 reads
Tesla is updating their software in a real world, real life DevOps that their customers experience every day. It impresses Steve and tempts him to get one of their cars.
2021-05-31
187 reads
It's a holiday weekend in the US this weekend. As such, many of you will be taking a break from work and enjoying time with family, as well as remembering some history in the US. If you're in the rest of the world, hopefully you have a holiday coming up soon you can enjoy. One […]
2021-05-29
70 reads
2021-05-28
156 reads
Forcing users to agree to a new EULA or removing features seems like a bad idea to Steve.
2021-05-26
164 reads
Steve looks at a technique that some think will allow more data to be used in research and training.
2021-05-24
112 reads
2021-05-22
142 reads
Both Python and R have become very popular languages in the last few years, especially among data professionals. Which should you learn or use? Steve has a few thoughts.
2021-05-21
408 reads
2021-05-19
216 reads
2021-05-17
225 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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