The 2024 Plan
On the last working day of 2023, Steve says you should think about making a 2024 plan for your career.
2023-12-29
208 reads
Editorials
Some Relief But Still Some Concern
Steve is relieved that he hasn't updated sqlmemorial.org this year, but worries he's missed remembering some of our colleagues.
2023-12-27
168 reads
2023-12-25
55 reads
A Thrill of Hope
I realize that this isn’t the last Database Weekly editorial of the year – that honor is reserved for Louis Davidson next week. 😊 However, as we approach the end of the year and various holiday celebrations, one of my favorite Christmas carols has been of particular encouragement to me recently. 2023 hasn’t gone exactly […]
2023-12-23
60 reads
Building CyberSecurity Skills with an Advent Challenge
Steve has been doing a cybersecurity advent challenge and has found it to be interesting, fun, and career building.
2023-12-22
145 reads
AI In the Nov 2023 Enterprise
An OReilly Radar report on AI has some interesting data to Steve. Read what he thinks about the state of this technology in 2023.
2023-12-20
183 reads
Migrations are Worth the Effort
Steve prefers database migrations as a way of making changes to a database, though he knows they are hard. He gives a few reasons to choose them.
2023-12-18
194 reads
A Thriving Community Lifts All Boats
I'm writing this on the last day of PGConf.EU, sitting here in Prague. I'm looking forward to sitting in several more sessions today, as well as having a few more conversations with the people at the conference. It's been a great event and I'm so happy I've been able to take part. Following the PASS […]
2023-12-16
62 reads
Try, Try Again, Until It's Right
A cloud migration for DoorDash interested Steve, primarily because it didn't work, but they were able to back out and try again.
2023-12-15
162 reads
2023-12-13
250 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