2025-06-02
515 reads
2025-06-02
515 reads
I wrote an editorial on the view of GenAI tech from execs and someone commented that they wanted references for results. Most of us might take a result from...
2025-06-02
29 reads
Steve has advice for students looking to become data professionals.
2025-06-02
151 reads
2025-05-30
353 reads
falesia– n. the disquieting awareness that someone’s importance to you and your importance to them may not necessarily match – that your best friend might only think of you...
2025-05-30
16 reads
I read Brent’s first look at SSMS and Copilot in there. He didn’t have a great opinion of the tool, especially comparing it to Gemini or Claude. I haven’t...
2025-05-30
101 reads
Who among us hasn't deleted a production data file? Steve hopes most of us have not.
2025-05-30 (first published: 2025-05-12)
208 reads
AI is changing work, sometimes for the better, sometimes not. Steve continues to examine and evaluate how GenAI systems might be used in today's world and asks if there is work that might help you.
2025-05-28
133 reads
2025-05-28
352 reads
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN FROM wp_posts WHERE post_parent = 94341; ) UPDATE p SET...
2025-05-28
146 reads
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers