Assembling Your Own Toolbox
Building a toolbox of useful scripts and code is important for any technology professional.
2022-10-07
269 reads
Editorials
The Value of Seniority
Some people might seem like they are from the future, but their experience is just shining through.
2022-10-05
172 reads
The Growth of IQP
Steve talks about some of the Intelligent Query Processing improvements in SQL Server 2022.
2022-10-03
259 reads
How Important is Software?
The user experience from our software is important. Maybe more than many developers realize.
2022-10-01
61 reads
Cloud Databases
There are advantages of cloud databases when your workload requirements grow. Steve thinks it's useful to learn a bit about the options out there.
2022-09-30
544 reads
The Right Connection
Making a connection to the wrong database had disastrous results for Travis-CI.
2022-09-28 (first published: 2018-04-19)
233 reads
2022-09-26 (first published: 2018-03-16)
361 reads
The Communication Channels at Work
The use of messaging dominates communication for Steve. Can you say the same thing?
2022-09-23
83 reads
Custom SQL Server on RDS
SQL Server on RDS has a more configurable option that allows you to meet the specific requirements of your application in a similar was as you would on-premises, while still being a managed service.
2022-09-21
194 reads
Are You a Traffic Cop?
A traffic cop isn't a great analogy for a DBA, but all too often it is an accurate one.
2022-09-19 (first published: 2018-03-20)
289 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