Better Training
What are better ways to train people to work in the technology field? Steve Jones has a few ideas.
2014-05-13
183 reads
Editorials
Calling Local Speakers
Steve Jones asks for more of the local people to help teach, train, and grow the community.
2014-05-12
103 reads
Just Enough know-how
As a professional, our knowledge of a given task should extend, at a minimum, one level deeper than is strictly necessary to perform the task. Anything deeper can be left to the ridiculously smart, or obsessive, or both
2014-05-12
122 reads
Backup Responsibility
Backups are important in most companies and today Steve Jones asks who has the responsibility in yours.
2014-05-09
194 reads
No Handwaving Away the DBA
Steve Jones doesn't think that companies can just do away with a DBA. Apparently there are people on the NoSQL platform that agree.
2014-05-08
258 reads
Managers
Steve Jones thinks that the attitudes of managers need to change if we want to be more productive in the future.
2014-05-07
177 reads
Vocation or Career
Do you have a vocation or career? Steve Jones talks a bit about the difference today.
2014-05-06
162 reads
Better, Faster, and Cheaper
When building a system, you need to make choices. However, do you always need to make the choice of only two of the three "good, fast, or cheap" choices? Andy Warren has a few thoughts.
2014-05-05
206 reads
Lots of Security Concerns
This past week saw lots of security concerns, especially around data. Steve Jones has a few comments about the implications.
2014-05-05
102 reads
The Gadget Itch
What would build if you had time? Anything fun or interesting? What's on your mind if you're a maker?
2014-05-02
134 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