2026-01-07
80 reads
2026-01-07
80 reads
Today Steve talks about the need for a basic level of security in our software.
2026-01-05
73 reads
2026-01-02
78 reads
2025-12-31
89 reads
2025-12-29
77 reads
The tally table is a valuable tool for a SQL Server developer, but how many of you understand how to create and use one?
2025-12-26 (first published: 2015-08-13)
808 reads
On the first day of Christmas my new DBA sent to me A table with a primary key On the second day of Christmas my new DBA sent to me Two Foreign Keys, and A table with a primary key On the third day of Christmas my new DBA sent to me Three stored procs […]
2025-12-24 (first published: 2019-12-24)
361 reads
We might be smart in one area, but not others. That's worth remembering.
2025-12-22 (first published: 2016-06-16)
197 reads
Microsoft gives a year in review from the SQL Server and Azure SQL teams. Steve sees a lot of accomplishments from this past year.
2025-12-20
82 reads
Today Steve asks what value you get from attending conferences or other events.
2025-12-19
44 reads
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers