In the intricate world of business, where precision and efficiency are paramount, managing database dependencies can often feel like navigating a labyrinth. Imagine having a tool that not only...
2025-05-05 (first published: 2025-04-21)
274 reads
If you are not embarrassed by your past self, you have probably not grown up yet. – from Excellent Advice for Living While I’d like to think most of...
2025-05-02
12 reads
I heard someone say recently that you can’t change a primary key value in a row. That’s not the case, so I decided to show a quick proof of...
2025-05-02 (first published: 2025-04-23)
470 reads
Now that I've completed both TOGAF 9 tests, I am putting up a couple of quick posts on how I prepared for these Enterprise Architecture exams.
2025-05-02
23 reads
You can now run powerful LLMs like Llama 3.1 directly on your laptop using Ollama. There is no cloud, and there is no cost. Just install, pull a model,...
2025-05-02 (first published: 2025-04-17)
398 reads
No tour this year, but Redgate does have a few DevOps events scheduled. I’m hoping for more, and the first one for me this year is Atlanta. You can...
2025-05-01
18 reads
Ever tried to request SQL Server funding from the CFO? Your systems, your data, your customer experience – they all rely on that “invisible” database engine humming along behind...
2025-05-01
42 reads
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best way). It was incredible to see so many folks in Redmond for the MVP Summit,...
2025-04-30 (first published: 2025-04-15)
194 reads
I had a customer recently ask about a change in one of their constraints on production, where a new option appeared when they went to deploy some changes from...
2025-04-30
126 reads
This is not database related, so if you’re not interested in hearing about something besides SQL Server, PostgreSQL, DevOps, community or data management in general, time to move on....
2025-04-30
18 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 Strange String Splits
Hi. I hope someone can give some useful suggestions. My workplace have a suite...
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