2017-01-06
93 reads
Editorial
2017-01-05
82 reads
Number Security
Numbers are both very useful and also susceptible to all sorts of attacks when their domain is limited. Steve Jones looks at some issues occurring in today's world.
2017-01-04
103 reads
2017-01-03
310 reads
2016-12-30
113 reads
2016-12-29
78 reads
Syntactic Sugar
Syntactic sugar doesn't necessarily help a platform, but makes it easier or more fun to work on.
2016-12-27
187 reads
The Toolchain for the Job?
Phil Factor ponders the use of toolchains in automation, and wonders if there might not be a better way.
2016-12-19
115 reads
A Fun Distraction
With the holiday season here, Steve Jones wonders what you'll do for fun away from work.
2016-12-16
118 reads
2016-12-14
70 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