2010-11-01
1,598 reads
Blogs
Why You Should Vote for My SQLRally Pre-Con
Self-marketing is not my strong suit. I don't feel very comfortable doing it, but Andy Warren (twitter | blog) suggests that we...
2010-11-01
2,380 reads
Get Out The Vote
It’s actually kind of cool that SQL Rally voting for the pre-conference seminars and voting in the real(ish) world in the USA are coinciding. I’m in the running for the pre-con AND I’m volunteering for an actual election campaign for the first time ever.
2010-11-01
1,038 reads
Vote for my precon workshop for PASS SQLRally
I’m one of the 3 lucky guys whose submitted precon workshop for the developer category
for PASS SQLRally is in the...
2010-10-28
542 reads
SQL Rally: One Day on Query Performance Tuning
The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This...
2010-10-28
1,512 reads
You know you want it! - SQLRally Precon Voting
For those of you who have seen our team present, we always do our best to make it really informative,...
2010-10-28
1,025 reads
Vote For The SQLRally Pre-Con Seminars
Do you know a real-life Pointy Haired Boss? Maybe you don’t work for him, but I bet you’ve met one.
In...
2010-10-28
873 reads
When was SQL Server Restarted?
While doing some performance testing recently and utilizing some of the DMV’s I figured, I better find out when the...
2010-10-21
2,806 reads
Powershell is Really Easy… If you know what you’re doing
Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...
2010-10-20
4,525 reads
T-SQL Tuesday #12 - Misconceptions
It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...
2010-10-14
2,273 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
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