Keeping MS Docs Up to Date
One of the things that I like about the SQL Server docs (MS Learn Docs) is that I can fix things I find wrong. For years we had downloaded...
2026-01-09 (first published: 2025-12-10)
246 reads
Blog Posts
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer (ALB) and Network Load Balancer(NLB). And, our good friend S3 now supports post-quantum TLS key...
2026-01-09 (first published: 2026-01-08)
12 reads
Self-Hosting a Photo Server the Whole Family Can Use
Until recently, my family's 90,000+ photos have been hidden away in the depths of my gaming PC's hard drives. Many of the more recent photos were also scattered across...
2026-01-09 (first published: 2025-12-24)
1,073 reads
Another Change
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity firm. There are no details of terms, and you can read the press release. It’s...
2026-01-07
14 reads
Start with the FabricTools PowerShell module
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the UI. Workspaces, capacities, and tenant-level settings all need repeatable, scriptable management. FabricTools is a community-driven PowerShell module...
2026-01-07 (first published: 2025-12-24)
232 reads
Stop Being Surprised by Your Azure Bill: Use Budgets
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and security. Cost management should be part of that conversation—but in practice, it’s often treated as...
2026-01-07 (first published: 2025-12-22)
247 reads
I recommend Smart Brevity (book) for communications
Following the advice in Smart Brevity improves communication.
2026-01-06
15 reads
Monday Monitor Tips: Native Replication Monitoring
Redgate Monitor has been able to monitor replication for a long term, but it required some work from customers. Now we’ve added native monitoring. This is part of a...
2026-01-05 (first published: 2025-12-15)
283 reads
Resetting on the AI hype train
There's a great article from MIT Technology Review about resetting on the hype of AI. AI's current state is somewhere between the die hard evangelists and the doomsayers
2026-01-05 (first published: 2025-12-19)
369 reads
Advice I Like: Pyramid Schemes
If someone is trying to convince you it’s not a pyramid scheme, it’s a pyramid scheme – from Excellent Advice for Living For sure. As much as I am...
2026-01-02
18 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers