Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today on Day 4 I would like to write about the Transformer architecture — the foundation...
2026-03-18 (first published: 2026-03-04)
179 reads
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI, Today on Day 3 I would like to write about LLM models — Open Source...
2026-03-13 (first published: 2026-03-03)
347 reads
I wrote about TempDB Internals and understand that Tempdb plays very important role on SQL Server performance and everything temporary / memory spill comes to tempdb and it is...
2026-03-09 (first published: 2026-03-02)
462 reads
I wrote about TempDB Internals and understand that Tempdb plays very important role on SQL Server performance and everything temporary / memory spill comes to tempdb and it is...
2026-03-02
2 reads
continuing from Day 1 where we covered the history of AI and GPT family, today on Day 2 i would like to discuss what came next after Generative AI...
2026-03-02
18 reads
it has been a year since i have not written much on the blog and i would like to start a “blog a day” series. i have been continuously...
2026-03-01
23 reads
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part of all the Versions!! 7 (70)– Foundation, OLAP Services, Query Analyzer 2000 (80) – SSAS,...
2026-02-27 (first published: 2026-02-26)
20 reads
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release /revolution from Microsoft SQL Server prospect, including – AI Buildin’, as AI plays an important...
2025-01-19
127 reads
As this is an Artificial Intelligence (AI) World, things are changing. We can see that everywhere you look, even now, when writing a blog, I could feel it today :)....
2024-12-01
33 reads
this month is the big month and a month to remember their are so many announcements has been done in this month – May -2024 . As this is...
2024-05-23
27 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