Grouping Sets
I have given a talk about new data types and T-SQL features to three local groups. I am presenting it...
2008-11-28
2,211 reads
Blog Posts
Database Adminstration Scalability
database administration scalabilityI am working on a project that is very successful in terms of its market
share, i.e. product users...
2008-11-27
1,869 reads
Does regulation make data any safer?
Working with healthcare organizations, I am constantly aware of the restrictions my staff and I must abide by according to HIPAA constraints. ...
2008-11-27
1,670 reads
Pumpkin Tossing
One more holiday post. Hope you all enjoyed Thanksgiving and are now enjoying either a quiet and well deserved day...
2008-11-27
1,364 reads
Happy Thanksgiving
I'm cheerfully taking the day off today (and tomorrow too!), and I'm writing this a week in advance as I...
2008-11-26
1,458 reads
Surface Demo
Second try. The video didn’t embed in the previous post. Nor this one. Here's the link
Microsoft Surface Demo
This is from...
2008-11-26
1,432 reads
Surface Possibilities
This is interesting. I’m not sold on Surface, though I did play with one last week in Seattle.
2008-11-26
1,389 reads
Workaround Primary Key Violations in SSIS
Before you get much further, please do not use this for every case where you have issues with duplicate rows....
2008-11-26
1,520 reads
Airlines Don't Care About Customers? Nor Does The Government!
I saw this post about a recent panel that tried to come up with guidelines for airlines as far as...
2008-11-25
1,387 reads
Catching Up
My goal of 400 posts a month has been in jeopardy with all the traveling I've been doing over the...
2008-11-25
1,479 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