A Quick Turnaround
Steve has a quick turnaround between trips that was a bit unexpected. Is there compensation for this?
2024-07-29
156 reads
Editorials
We Stink!
You know I have to say something about Crowdstrike. How could I not? Recovery for most people seems to be well in hand, but there are still places dealing with it. I was personally impacted because I was trying to fly home last Friday. While my airline and the airports I was flying through were […]
2024-07-27
144 reads
I may need to re-think the use of table variables
Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.
2024-07-26 (first published: 2018-12-11)
339 reads
Thinking About Technology
Steve is thinking about technology today, inspired by a developer/architect that asks some philosophical and moral questions of software.
2024-07-24
158 reads
The Biggest Database Professional Challenges Today
What are the biggest challenges you face today? Steve asks the question and is hoping for a few answers from you.
2024-07-22
186 reads
Planes, Trains, and Automobiles
I remember going to the theater over the Thanksgiving holiday in 1987 and seeing Planes, Trains, and Automobiles with Steve Martin and John Candy. My family didn’t often take in the holiday weekend movie releases, but Steve was a family favorite actor already, and friends had given it a good review. Having watched it just […]
2024-07-20
181 reads
A Programmer's Attitude
The way we approach development can have a big impact on quality, as well as how smoothly our team works together.
2024-07-19
166 reads
Cloud vs On-premises
Is the cloud better or worse for a workload? One company, BlueSky, has moved on-premises despite their rapidly growing workload.
2024-07-17
355 reads
Least Privilege
Steve wonders how well most organizations and their staff adhere to the principle of least privilege.
2024-07-15
189 reads
The Danger of Safety Assistance Tools
During a speaker dinner the other week, a lot of topics were swirling around and a few caught my ear. One of these topics dovetailed nicely with a mistake I recently made. More on that later. The discussion was on the effect on safety that all the new safety-based tech is having on driving. Some […]
2024-07-13
80 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