The Era of Cloned Humans
AI has tremendous possibilities but also a number of security issues. Steve highlights one scary security issue today.
2025-01-27
115 reads
Editorials
Technical Pain Behaviors
In my family’s history of the past 10+ years, we have become well versed in nagging, ongoing, non-debilitating pain. In some ways, the lessons we have learned about physical pain correlate all too well to the types of pain that we technical people are involved with daily. But there is a huge difference, even if […]
2025-01-25
79 reads
Can You Become a More Productive Engineer?
Steve has a few thoughts on becoming more effective. This involves more than just becoming a better coder.
2025-01-24
156 reads
The AI Budget Assistant
Most of us don't work on budgets, but we are affected by them. Is it a good idea for IT management to use AI to help plan their budgets? Steve has a few thoughts today.
2025-01-22
99 reads
Why Tools Can Help You Do Your Job
This editorial was originally published on May 18, 2019. It is being re-run as Steve is on holiday. Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was […]
2025-01-20 (first published: 2019-05-18)
374 reads
2025-01-17
154 reads
The Managed Cloud Database Options
You have a number of options for moving your database to the cloud, but Steve has a few things you might want to consider before you do so.
2025-01-15
146 reads
Simple(r) Coffee
Choice is good, but too much choice can cause problems in both coffee shops and software teams, as Steve notes today.
2025-01-13
126 reads
The Weather Outside Is Frightful
Yeah, I know, holidays are over. It snowed about four inches overnight here and it's still coming down a little. You'll forgive me for having that song running through my head. Yesterday morning, before the storm started, we did a check through the house to make sure we were ready for a couple of days […]
2025-01-11
69 reads
The Lesser Used Functions
There have been a number of changes to the T-SQL language that are very specialized. Steve asks if you use any in your code?
2025-01-10
258 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