2005-12-13
2,193 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
2005-11-30
2,289 reads
Get MAXimum functionality
SQL 2005 provides a the new max specifier to be used with varbinary, varchar and nvarchar data types. You can...
2005-11-12
1,286 reads
SQL Diagnostic Manager Review
SQL Diagnostic Manager from Idera is a great tool for troubleshooting issues with your SQL Server databases. Kathi Kellenberher puts this tool through it's paces and gives you some insight into how it fits in a busy SQL Server environment.
2005-11-08
16,150 reads
On vacation!
It was busy at work after returning from PASS which means my work day continued for 2 or 3 hours after I got...
2005-10-16
1,286 reads
Something About Nothing: NULL
You wouldn’t think that “nothing” would cause so many problems. But seriously, understanding how to correctly use NULLs is a...
2005-10-16
1,385 reads
Using the sa account -- Just say "NO!"
Aunt Kathi knows many of you do things you know are wrong, like rolling through stop signs, littering, and using the sa...
2005-10-04
1,304 reads
Thoughts about the future
So far my posts have been non-technical musings about my life outside of work. I guess it is time to...
2005-10-03
1,245 reads
Back home after PASS
The past week at PASS was more informative and fun than I could ever have imagined. By getting involved in the...
2005-10-01
1,288 reads
Thinking about PASS
With PASS just a little over a week away, I realized that I had better fine-tune my presentation and practice...
2005-09-18
1,304 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