Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been to build an agent which would answer your questions by looking into your data. It...
2026-02-25 (first published: 2026-02-15)
227 reads
Blog Posts
Fabric Cost Analysis (FCA)
Monitoring costs in Microsoft Fabric can be trickier than it first appears. You might assume it’s just a flat fee per capacity (easy, right?), but real-world usage tends to...
2026-02-23 (first published: 2025-12-24)
361 reads
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day job, I certainly didn’t expect to write this many blog posts about Git. I don’t...
2026-02-23 (first published: 2026-02-12)
413 reads
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at dataMinds Saturday. It’s a topic close to my heart, and I’ve always wanted to present...
2026-02-20
22 reads
The Book of Redgate: SQL Server Central
It was neat to stumble on this in the book, a piece by me, just a few years after Redgate acquired SQL Server Central. I’ll let the words speak...
2026-02-20 (first published: 2026-02-13)
300 reads
tSQLt Test Adapter for Visual Studio 2022+
I have had a number of requests for me to update the tSqlt Test Adapter over the years so it would work with more recent versions of Visual Studio....
2026-02-20 (first published: 2025-12-30)
285 reads
Claude AI Convinced Me Not to Build an iPad App
I coach volleyball and I do a lot of stat stuff on paper. I decided recently to see if I could find a way to more easily automate things....
2026-02-18 (first published: 2026-02-09)
543 reads
SQL Server Upgrades: In-Place or New Server?
This isn’t a religious debate. I have a client right now debating how to handle SQL Server upgrades across all of their dev and test environments. And it’s...
2026-02-18 (first published: 2025-12-31)
416 reads
Claude Code Helps Analyze Test Data Manager Log Files
I had a customer ask about analyzing their Test Data Manager (TDM) usage to determine how many people were protecting data in dev databases and how often. TDM creates...
2026-02-16 (first published: 2026-02-04)
256 reads
PowerPoint to HTML with Claude AI
I had an idea for an animated view of a sales tool, and started to build this in PowerPoint. I decided to switch to Claude and ended up with...
2026-02-13 (first published: 2026-02-03)
374 reads
Blogs
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
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...
Forums
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
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...
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