T-SQL Tuesday #196: Taking Risks
This month we have a new host, James Serra. I’ve been trying to find new hosts over the last few years to keep this party going and to expand...
2026-03-10
12 reads
Blog Posts
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector databases — all comes together here! What is RAG? all the AI model has predefined...
2026-03-09 (first published: 2026-03-08)
21 reads
AI: Blog a Day – Day 9: HuggingFace – The Home of AI Models
today on Day 9 I would like to talk about HuggingFace. if you are learning AI practically, HuggingFace is one of the most important platforms you will come across....
2026-03-09
5 reads
Building Power BI Reports: Desktop vs Fabric
Why this comparison feels confusing If you’re a Power BI report author who’s just getting into Microsoft Fabric, you’ve probably asked the same question I hear over and over:...
2026-03-09 (first published: 2026-02-26)
532 reads
Monday Monitor Tips: AI Query Analysis
AI is everywhere. It’s in the news, it’s being added to every product, management wants everyone to be more productive with AI. Redgate Monitor isn’t immune from this wave....
2026-03-09
21 reads
Semantic Model Power Query vs Dataflow Gen2 in Fabric
In my recent blog post, Building Power BI Reports: Desktop vs Fabric, I talked about the evolving authoring experience in Microsoft Fabric and how report development is increasingly moving...
2026-03-09
45 reads
TempDB Internals – What’s New (SQL Server 2016 to 2022)
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)
483 reads
The First Steps: Understanding the Basics of FinOps
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out of control without the right practices in place. That’s where FinOps comes in—it’s a powerful...
2026-03-09
17 reads
Advice I Like: In 100 Years
In 100 years a lot of what we take to be true now will be proved to be wrong, maybe even embarrassingly wrong. A good question to ask yourself...
2026-03-06 (first published: 2026-02-20)
591 reads
The Book of Redgate: Mistakes
This is kind of a funny page to look at. The next page has more detail. This is the text from the facing page: What we do is very...
2026-03-06
36 reads
Blogs
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers