-
REGEXP_ Functions in SQL Server 2025 – REGEXP_SUBSTR
Read more: REGEXP_ Functions in SQL Server 2025 – REGEXP_SUBSTRPart 10 of Learn RegEx With Louis The REGEXP_SUBSTR function extracts parts of a string based on a regular expression pattern. It has some similarieties with the SUBSTRING function, but with some important (and interesting) differences. This function returns Nth occurrence of a substring that matches the regex pattern. As I am sitting here looking…
-
T-SQL Tuesday #190 – Mastering A New or Existing Technical Skill
Read more: T-SQL Tuesday #190 – Mastering A New or Existing Technical SkillThank you to Todd Kleinhans for this week’s invitation. I didn’t see it until today when I saw Steve Jones’ reply (and this is why it is going on my list of feeds I follow this week!) Usually I just go “bah, I am too late to reply. This topic is different. First of all,…
-
Testing in Production
Read more: Testing in ProductionThis is a practice that is commonly preached against by any serious testing advocate. “Never test in production; you must test your software from the design phase, making sure your design will meet the requirements.” So you unit test your modules, integration test your code with the larger system, and acceptance test with the user…
-
Feedly Friday – Feeds I Read #6 – Erik Darling and Eugene Meidinger
Read more: Feedly Friday – Feeds I Read #6 – Erik Darling and Eugene MeidingerFeeds I Read Page | Other Feedly Friday Posts Welcome to my continuing series of posts where I am going to highlight one or two feeds I follow in my Feedly feeds. Technology feeds only, though I keep up with other things like theme park news in there too. Feedly is an RSS reader that you can use that…
-
REGEXP_ Functions in SQL Server 2025 – REGEXP_SPLIT_TO_TABLE
Read more: REGEXP_ Functions in SQL Server 2025 – REGEXP_SPLIT_TO_TABLEPart 9 of Learn RegEx With Louis Continuing on with the REGEXP_ functions series, the next one I want to cover is the table valued function REGEXP_SPLIT_TO_TABLE. This function is definitely one of the ones you probably ought to know, especially if you are ever tasked to pull some data out of a data structure.…
-
Feeds I Read – Feedly Friday #5 – Niko Neugebauer
Read more: Feeds I Read – Feedly Friday #5 – Niko NeugebauerFeeds I Read Page | Other Feedly Friday Posts Welcome to my series of posts where I am going to highlight one or two feeds I follow in my Feedly feeds. Technology feeds only, though I keep up with other things like theme park news in there too. Feedly is an RSS reader that you can use that is…
-
REGEXP_ Functions in SQL Server 2025 – REGEXP_REPLACE
Read more: REGEXP_ Functions in SQL Server 2025 – REGEXP_REPLACEPart 8 of Learn RegEx With Louis Okay, we have gone through as much of the RegEx filtering as I think is a a part of the SQL Server 2025 implementation. Now it is time to focus on the functions that are not REGEXP_LIKE. We have already talked about REGEXP_MATCHES, which will come in handy…
-
Breaks, Creativity, and a Side of Obsession
Read more: Breaks, Creativity, and a Side of ObsessionThis following statement is so true: “Sometimes the most creative ideas come when you take a break.” – Elena Drakulevska And I am not contradicting it at all with what I am going to type here. Anytime I am stuck on a problem, or am bereft of new ideas to write about; breakfast, coffee, a…
-
Feedly Friday – Feeds I Read #4 – Brent Ozar Unlimited
Read more: Feedly Friday – Feeds I Read #4 – Brent Ozar UnlimitedFeeds I Read Page | Other Feedly Friday Posts Welcome to my series of posts where I am going to highlight one or two feeds I follow in my Feedly feeds. Technology feeds only, though I keep up with other things like theme park news in there too. Feedly is an RSS reader that you can use…
-
Flags in SQL Server Regular Expressions – Multiline Processing
Read more: Flags in SQL Server Regular Expressions – Multiline ProcessingPart 7 of Learn RegEx With Louis In this week’s seventh entry of my learning RegEx series, I am going to do one last intro into expressions entry for a while. Next I will move into all of the functions that are available in SQL Server 2025 and Azure SQL (and I will come back…
Hello,
I’m Louis
I have been at this database thing for a long long time, with no plans to stop.
This is my blog site, companion to drsql.org
Drsql.link 