PowerShell Newbie – Variables
This is Week 2 of PowerShell Strikes Back – a four-week May series for SQL Server DBAs who have dabbled in PowerShell but never stopped to nail down the...
2026-05-27 (first published: 2026-05-11)
234 reads
Blog Posts
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same frustrating issue. Applications and SSMS sessions that had been rock-solid for years suddenly started throwing...
2026-05-27 (first published: 2026-05-07)
129 reads
Claude Desktop
Claude is more than a chat window. The desktop experience includes structured workspaces, generated outputs, integrations, execution capabilities, memory and reusable workflows. This is a quick introduction to some...
2026-05-26
14 reads
PowerShell Strikes Back: A New Script
This is it. The final chapter of PowerShell Strikes Back. Over the past four weeks, you’ve built a real foundation. You know that single quotes are literal and double...
2026-05-26
69 reads
The end of an era – why I chose not to renew my MVP
Two years ago, two things happened within a few days of each other. I retired from 3Cloud going on full time disability due to ALS, and I was awarded...
2026-05-26
21 reads
Claude.ai vs Claude API
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and mobile apps) is the chat product you talk to. The Claude API is the developer...
2026-05-25 (first published: 2026-05-13)
276 reads
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered requires SQL Server to participate in the snapshot: the write IO freeze, the metadata backup,...
2026-05-25 (first published: 2026-05-08)
97 reads
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one correctly for small tables or queries that return most of a table's rows. The dangerous...
2026-05-25
11 reads
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an AI agent genuinely useful for database work, both for administration and for application access to...
2026-05-24
39 reads
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many data engineers face the challenge of leveraging its cutting-edge features while maintaining performance and reliability....
2026-05-22 (first published: 2026-05-04)
156 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers