2022-10-14
167 reads
Editorials
Code Supply Chain Security
Building software is becoming harder as new attacks try to inject malicious code into products.
2022-10-12
121 reads
Things I've Learned About the Cloud
Steve shares a few things he's learned from customers trying to migrate their systems to cloud computing platforms.
2022-10-10
235 reads
Learning New Technology Is Challenging
On nights and weekends, I've been playing with Arduino controllers. I have a couple of projects I'm working through (building a robot that can roll around with "eyes" to avoid obstacles). I've also been trying to work with STM32 controllers, because in a lot of ways, they're more powerful than an Arduino. However, I've hit […]
2022-10-08
154 reads
Assembling Your Own Toolbox
Building a toolbox of useful scripts and code is important for any technology professional.
2022-10-07
269 reads
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
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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