I’m speaking at the Data Saturday Holland!
As you may have noticed, the agenda for Data Saturday Holland was recently published. I’m delighted to share that I will be conducting a full-day precon on October 7,...
2023-08-01
18 reads
As you may have noticed, the agenda for Data Saturday Holland was recently published. I’m delighted to share that I will be conducting a full-day precon on October 7,...
2023-08-01
18 reads
It’s an honor to host this month’s T-SQL Tuesday. In case you don’t know the rules already, here is a recap of them: Earlier this year, when I was...
2023-08-01
136 reads
A high level view of the most costly queries by CPU
I want to see at a high level i.e at batch or stored procedure level, not at the individual...
2023-07-31 (first published: 2023-07-13)
1,329 reads
I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. Since this...
2023-07-31 (first published: 2023-07-12)
276 reads
fitzcaraldo – n. a random image that becomes lodged deep in your brain – maybe washed there by a dream, or smuggled inside a book, or planted during a...
2023-07-28
18 reads
Earlier this week the emails went out to speakers who submitted to the PASS Data Community Summit 2023 conference. These were acceptances and rejections, letting people know the results...
2023-07-28 (first published: 2023-07-13)
145 reads
I was having a conversation with some friends the other day and Jen McCown (blog|twitter) asked about SQL Server security ... Continue reading
2023-07-28 (first published: 2023-07-13)
310 reads
I stopped blogging late last year. I’ll be honest, I was tired. I had decided to take a month or ... Continue reading
2023-07-27
31 reads
It’s been a while, but I’m finally participating in T-SQL Tuesday again! This month Erik Darling (blog|twitter) is hosting. Ever ... Continue reading
2023-07-26 (first published: 2023-07-11)
352 reads
The invitation this month is from Erik Darling, and it’s a neat one. I like this thought, asking us to find code that impressed us or made us feel...
2023-07-26 (first published: 2023-07-11)
444 reads
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Keeping up with Form W-4 updates doesn’t have to be complicated. In this practical...
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Comments posted to this topic are about the item Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers