Clustered Indexes
I work almost exclusively with third party applications. I don't get to do a lot of tuning except for reports...
2007-09-30
1,291 reads
Blog Posts
The Quickest Podcast in the Business
I almost forgot to record the podcast for tomorrow's editorial. In case you're a glutton for punishment, it's here. I'd...
2007-09-30
1,603 reads
I Don't Have a Black Eye
Though it kind of looks like that. Here's the first video podcast.
Halo 3
Actually it's probably the 20th, but it's close...
2007-09-29
1,442 reads
Monitoring and Alerting
I responded in an interesting thread this morning where someone was looking for advice on what to monitor on their...
2007-09-28
1,562 reads
Points or Posts
It's an interesting question that we had come up, and honestly I'm not completely sure what I want. I'll describe...
2007-09-27
1,414 reads
I Am Not In Charge
That is for sure.
We had a development meeting today with my publishing team (meaning I'm on the team, not leading...
2007-09-26
1,458 reads
Development at High Speed
As with any project, despite being fairly pleased with the final product, there were bugs. In fact, quite a few...
2007-09-25
1,379 reads
DTS vs Linked Server
We are trying to move to version 2 of our accounting data warehouse (more likely called a datamart), but it...
2007-09-25
1,599 reads
Flawed URL Validation and Not Eating Your Own Dog Food
MS includes a bunch of reasonably nice validation controls in VS 2005 and one of them includes the ability to...
2007-09-25
1,380 reads
Writing in my sleep
When I first got into IT full time 10 years ago, I noticed that my mind was constantly solving programming...
2007-09-25
1,270 reads
Blogs
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...
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
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