During my technical career, I’ve changed companies several times. I even worked as an independent contractor for three years. One thing I have never done before was switch departments and roles within one company. That’s about to change in a couple of weeks as I move from Simple Talk Editor and DevOps Advocate in Marketing […]
2022-05-21
103 reads
Do you know how to answer normalization questions in an interview? Steve Jones gives you a few ideas and recommends you brush up on your knowledge.
2022-05-20 (first published: 2018-01-11)
649 reads
It seems that many people who choose NoSQL platforms still need relational features. Steve speculates on why.
2022-05-18
154 reads
2022-05-16 (first published: 2018-01-15)
289 reads
This week I was honored to be able to attend, and present a session at, SQLDay in Wroclaw Poland. I fell in love with Poland the very first time I attended this event, so I look forward to any time I can go again. This year, Pavel Potasinski presented the keynote: The Evolution of the […]
2022-05-14
126 reads
2022-05-13
1,430 reads
Steve feels it is not only important to keep your word, but communicate clearly what you mean to others.
2022-05-11
357 reads
Interviews are always a challenge, but sometimes there are crazy questions. We can do better, especially in terms of how we evaluate the answer to a question.
2022-05-09
543 reads
You can find new employment with a little work and choose the best job for you.
2022-05-07
138 reads
2022-05-06
83 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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