Every PostgreSQL migration eventually hits the same fork in the road. The database is small enough to dump and restore in a maintenance window, or it isn't. Once you...
2026-07-15 (first published: 2026-07-03)
270 reads
The DBA life is fraught with pain. Those battles that we endure are mostly invisible to many. Those countless sleepness nights are a testament to our dedication. Whether that...
2026-07-15 (first published: 2026-07-06)
641 reads
I had a question the other day that constantly pops up on my feed whether it’s on social media or people asking Q&A at a conference etc. And that...
2026-07-15 (first published: 2026-07-13)
129 reads
A New Chapter: Why I Made the Move from Dayforce to ESO Over the past several weeks, many of you have probably noticed subtle hints throughout my blog. A...
2026-07-14
52 reads
The slides for my session “The €100 data warehouse on the Azure data platform” can be found on GitHub. It was a calm event, probably because of the good...
2026-07-14
30 reads
When you have a project or system, it has to be optimized, tuned, and we must ensure it is consistently performing better. For this, we should use the Lean...
2026-07-14
38 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Brent Ozar
(blog) asks us to fill in the blank:
When I’m looking at...
2026-07-14
65 reads
One of the things I’ve been requesting for a number of years is cost information. I could see this coming in 2015 with the move to the cloud and...
2026-07-13 (first published: 2026-06-29)
223 reads
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related and grouped as follows: Process Group[49] Knowledge Area with Process I will write detail blog...
2026-07-13
43 reads
NO AI was used to generate this content. Grammarly was used to check and correct language and sentences in parts. I just managed to get a post in for...
2026-07-13
159 reads
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers