I'm writing this while in hiding at the PASS Data Community Summit that's taking place in Seattle this week. I just had a real surprise, finding out that DocumentDB is PostgreSQL under the covers and always has been. However, as much as I enjoy talking PostgreSQL, for the moment, I'll shut up about it. Instead, […]
2025-11-22
72 reads
2025-11-21
149 reads
Today we have a guest editorial reminding us that business knowledge is important, and we could all use some training.
2025-11-19
134 reads
AI can help us do more, but do we need to do more? Or more importantly, are we doing a good job of producing more useful stuff?
2025-11-17
186 reads
2025-11-15
98 reads
Do you take the time to model and design your database? Steve thinks this is important, even while trying to make changes quicker to adapt to changing requirements.
2025-11-14
94 reads
How do you approach adding to your team? Steve asks if you look internally or externally as a default.
2025-11-12
84 reads
Steve asks the question about whether or not a particular environment really needs HA implemented.
2025-11-10
140 reads
Artificial intelligence is everywhere: It’s in our tools, our workflows, our marketing pitches…and increasingly, in our bottom lines. But a thought-provoking article published recently on the AI bubble asks a far more sobering question: What’s it really going to cost to profit from AI? Many people will roll their eyes and say, “Isn’t that obvious? […]
2025-11-08
96 reads
Steve has a few thoughts on the names we choose for tables, columns, files, and more.
2025-11-07
137 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