2026-02-25
6 reads
software development
Can You Let Go of Determinism
As Steve uses AI more, it seems determinism isn't something you get out of many LLMs.
2026-02-23
73 reads
Deep Learning and Craftsmanship Matter
GenAI technology is going to change coding, but there is still a lot of work available for humans.
2026-01-26
86 reads
2026-01-21
89 reads
Eight Minutes
When I was at the Small Data 2025 conference, one of the speakers was talking about their work with AI technologies. This person uses it a lot in their day job, often to complete tasks that they would have struggled to work on in the past, mostly because of time constraints, but also a lack […]
2026-01-16
147 reads
Refactoring SQL Code
Refactoring code is a common task in many software development teams. Steve asks if this is something common for database developers as well.
2025-12-12
236 reads
Done is Better than Good
Getting something done is important, but so is the quality level. Steve has a few thoughts today.
2025-11-26
96 reads
PRs Are Like Trouble Tickets
Adopting a modern development approach brings with it the need to manage PRs, which Steve thinks can be like trouble tickets.
2025-10-01
118 reads
Requiring Technical Debt Payments
Steve found someone using an interesting approach to get developers to address some technical debt.
2025-09-08
151 reads
The Technical Debt Anchor
Technical debt is something all of us deal with in our systems, and today Steve has a few thoughts on the impact of debt on database sysstems.
2025-06-25
167 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers