Making Sense of Microsoft’s AI Strategy: Work IQ, Fabric IQ, Foundry IQ
A few weeks ago, I found myself staring at a slide full of new Microsoft AI names and thinking… wait a second. Work IQ. Fabric IQ. Foundry IQ. Agent...
2026-02-12
23 reads
A few weeks ago, I found myself staring at a slide full of new Microsoft AI names and thinking… wait a second. Work IQ. Fabric IQ. Foundry IQ. Agent...
2026-02-12
23 reads
Hey everyone, Tim Radney here. Over the years I’ve seen far too many organizations learn the hard way what happens when you ignore database integrity checks. In traditional SQL...
2026-02-11
5 reads
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
After tempdb, msdb is often the most abused system database, growing unchecked until it tanks...
2026-02-11 (first published: 2026-01-30)
529 reads
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now runs successfully on Docker Desktop for macOS without needing OrbStack.
2026-02-11 (first published: 2026-02-02)
128 reads
For a number of years, we’ve produced the State of the Database Landscape report, based on surveys and research we do every year. I have found it very interesting...
2026-02-10
75 reads
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
If you’ve spent any time tuning SQL Server, you’ve probably heard “Turn...
2026-02-09 (first published: 2026-01-27)
316 reads
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting governance. With Fabric OneLake and open table formats like Iceberg and Delta, there are now...
2026-02-09 (first published: 2026-01-29)
336 reads
dolorblindness – n. the frustration that you’ll never be able to understand another person’s pain, only ever searching their face for some faint evocation of it, then rifling through...
2026-02-06
29 reads
Leave a gate behind you the way you first found it. – from Excellent Advice for Living This is a ranch rule. Leave something as you found it. If...
2026-02-06 (first published: 2026-01-30)
274 reads
This is long overdue but life and distractions happened. It’s been a little over two months since I returned home from PASS Summit 2025.
2026-02-06 (first published: 2026-01-26)
146 reads
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Good documentation gets you started. Good books get you deep. After years of working...
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
We have a SQL Server installed. We have a 500GB drive for the database....
Comments posted to this topic are about the item Creating a JSON Document IV
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
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