-
The Stages of My Layoff Grief – Part 1 – Bargaining, Anger, and Denial
Read more: The Stages of My Layoff Grief – Part 1 – Bargaining, Anger, and DenialWhen I started out to write my feelings down, I thought I would do this in 5 parts, one for each stage of the classic stages of grief. In addtion to those in the title, the other two are depression and acceptance. What I realized was that I actually had 2 distinct stages where I…
-
Repeating Pattern Matching with SQL Server Regular Expressions
Read more: Repeating Pattern Matching with SQL Server Regular ExpressionsPart 2 of Learn RegEx With Louis In the previous entry in this series, we looked at matching a straightforward pattern like “fred”, which in a regular expression would find any string that had the characters f, r, e, d in a row at least once. We also noted that using \b to surround your…
-
Every app is at least somewhat a data app
Read more: Every app is at least somewhat a data appOne of the things I think is important to understand when you start out to create an application is: The primary internal purpose of your application is data. That is why your company builds it, for the data that it can create. I am sure that somewhere there is an app that is created by…
-
Simple Pattern Matching with SQL Server Regular Expressions
Read more: Simple Pattern Matching with SQL Server Regular ExpressionsPart 1 of Learn RegEx With Louis I have never once written an regular expression prior to a couple of articles on this blog. And truth be told, when I published those blogs, I got the expression wrong because it seemed to work, and it was what Copilot told me would work. If you are…
-
My Simple Talk Experience from Dollywood to Dollywood
Read more: My Simple Talk Experience from Dollywood to DollywoodI sit here in Dollywood, at the same table where I had my first interview with Redgate, just over 3 years ago. It was a chilly April day, and I had to interview some of the Dollywood Hosts for an article for Dollywood (I was a Dollywood Insider at the time, though that program has…
-
T-SQL Tuesday #188 – Growing the Data Community
Read more: T-SQL Tuesday #188 – Growing the Data CommunityWhen I saw this invitation from John Sterrett come through, it piqued my interest. Getting people to startparticipating in the community has always been an interesting challenge. Even getting people go just go to conferences and participate in the data community isn’t exactly simple. There are a lot of reasons for this, but I want…
-
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…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
