There are moments in technology when the ground shifts beneath our feet. Moments when the tools we once thought of as reliable utilities suddenly become engines of transformation. SQL...
2025-10-06
138 reads
I don’t recall where this came up (probably in SQLSlack), but I had a need to install an older version of dbatools to test something related to loading the...
2025-10-06 (first published: 2025-09-16)
129 reads
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer with SQL Server 2025 RC 1 running in a Docker container. I know it was...
2025-10-06
170 reads
A customer wanted a report they could email to their boss about jobs, something that showed failures. This isn’t hard to get in Redgate Monitor, though it is manual...
2025-10-06 (first published: 2025-09-22)
223 reads
Why Developers Shouldn’t Have sysadmin access in SQL Server
7 reasons—and exactly what to do instead
It can feel “faster” to hand developers sysadmin. In reality, it’s like giving them the master...
2025-10-06
360 reads
ecstatic shock – n. a surge of energy upon catching a glimpse from someone you like, which scrambles your ungrounded circuits and tempts you to chase after that feeling...
2025-10-03
15 reads
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved a mystery alone. Scooby and Shaggy could sniff out a clue between snacks, but it...
2025-10-03 (first published: 2025-09-10)
204 reads
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?” What’s your first move? For me, it starts with the SQL Server Error log. I...
2025-10-03 (first published: 2025-09-11)
435 reads
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth, blocks covering-index usage, and makes code brittle when schemas change. Specify only the columns you...
2025-10-02
29 reads
The New Arena of Leadership The role of the Chief Data Officer is no longer about governance alone. It is about vision. It is about turning data into the...
2025-10-02
11 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Can/Can't Do/Don't
Comments posted to this topic are about the item Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers