Off to Live 360
I am off to Live 360 today, on my last trip of the year. I’m excited to deliver two presentations tomorrow (VSTH03 and VSTH12), but a little sad this...
2024-11-20
14 reads
Blog Posts
PASS Data Community Summit 2024 Day 3 Keynote
It’s been an amazing week here, as well as a long week. I’m tired, as are many others. The blogging table is a little bare this am, but I...
2024-11-20 (first published: 2024-11-08)
153 reads
Thoughts on AI Data Infrastructure Field Day #1
On October 2nd and 3rd, I took part in an amazing event called AI Data Infrastructure Field Day as a delegate. If you’ve never heard of this event before,...
2024-11-20 (first published: 2024-11-11)
208 reads
AI Innovation in Microsoft Keynote
I’m thrilled to be covering the Microsoft Keynote: Fuel AI Innovation with Azure Databases on Day 1 of the PASS Data Community Summit. Data is the driving force behind innovation, powering...
2024-11-18 (first published: 2024-11-06)
170 reads
Day 2 at PASS Data Community Summit 2024
I missed blogging yesterday as I was on stage/backstage for quite a bit of the keynote. Live updates, so keep refreshing. Today I’m blogging and noting the interesting things...
2024-11-18 (first published: 2024-11-07)
163 reads
Webcast Tomorrow on SQL Server Disaster Recovery
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL Server Disaster Recovery. It'll cover all the typical methods built-in to SQL Server, with a...
2024-11-18
17 reads
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if I need it somewhere in the future 🙂 Sometimes you need a numbers table (also...
2024-11-16 (first published: 2024-11-15)
315 reads
Spark Connect Dotnet November 2024 Where are we?
All Spark Connect Posts
Introduction There have been quite a few changes in the last couple of months and I just wanted to give a quick update on the current...
2024-11-16
76 reads
A New Word: Ochisia
ochisia – n. the fear that the role you once occupied in someone’s life could be refilled without a second thought, which makes you wish that every breakup would...
2024-11-15
17 reads
Counting Groups with Window Functions: #SQLNewBlogger
I looked at row_number() in a previous post. Now I want to build on that and do some counting of rows with COUNT() and the OVER clause. I’ll show...
2024-11-15 (first published: 2024-10-30)
463 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers