-
Cardinality and REGEXP_LIKE
Read more: Cardinality and REGEXP_LIKESo I was reading Brent Ozar’s post about Regular Expressions in SQL Server 2025 (T-SQL Has Regex in SQL Server 2025. Don’t Get Too Excited. – Brent Ozar Unlimited®) and why they work as they do, and in the comments, someone mentioned a couple of hints that should make it better. I couldn’t find much…
-
Explore Your Limits, They Aren’t Static
Read more: Explore Your Limits, They Aren’t StaticThis was to be my post for Saturday, June 14’s Database Weekly. But I have moved on from Redgate and on to different things. Ironically a lot of the posts I had written lately were about changing jobs. For example What’s Your Price and What About Loyalty?, not to mention a forthcoming piece from Sheila Romans about using…
-
SQL Server REGEXP_LIKE features augment, not replace, LIKE
Read more: SQL Server REGEXP_LIKE features augment, not replace, LIKESo I expect most people (like myself), before they learned anything about the new RegEx features of SQL Server 2025 (and the Azure SQL DB too), assumed they would include a direct replacement for LIKE. Filtering data on a pattern has always been an important need when querying string data. For the most part, LIKE…
-
Scenic City Summit Roundup
Read more: Scenic City Summit RoundupContinuing my new tradition of recapping conferences I have attended or worked on, I just got back from Scenic City Summit 2025 (https://sceniccitysummit.com/) and this was a doozy of a conference for me. It was the last conference I organized sponsorship for as the editor of Simple Talk, one I spoke at, and it was…
-
ChatGPT’s Attitude is interesting
Read more: ChatGPT’s Attitude is interestingI was trying to test out the RegEx capabilities in SQL Server 2025. I wanted to generate a really random, flexibly large set of data pretty quickly so I could just try to see if indexes are used ever with RegEx. So I asked ChatGPT, and then the fun kind of started. So, like any…
-
New Blog Home
Read more: New Blog Home”It isn’t much yet, but it is home” – Me, 10 minutes ago. After so many years, I am starting a new blog on my own site. I started blogging over 25 years ago on Microsoft’s live blogging platform. After that, I moved to SQLBlog.com, and when that died, the the. editor of SimpleTalk.com pulled…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
