-
Viewing Multiple Matches in SQL Server Regular Expression Functions
Read more: Viewing Multiple Matches in SQL Server Regular Expression FunctionsPart 5 of Learn RegEx With Louis The goal of this week’s entry is specifically to show how to see how multiple matches can be viewed using SQL Server’s RegEx, specifically to make the examples clearer (especially in the upcoming entries). There are several functions that you can use where multiple matches are used as…
-
Why do I blog?
Read more: Why do I blog?I always ask this question of myself occasionally, and sometimes quite frequently. Somewhat more now that blogging has reverted to a hobby rather than directly a vocation. The other night, as I was sitting at my desk at 12:30 AM writing a blog about regular expressions, I had a crisis of conscience. I had originally…
-
Feedly Friday – Feeds I Read #1 – Curated SQL and SQLBlog.org
Read more: Feedly Friday – Feeds I Read #1 – Curated SQL and SQLBlog.orgFeeds I Read Page | Other Feedly Friday Posts Welcome to my new 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…
-
Negating Character Classes and Class Shortcuts in SQL Server RegEx
Read more: Negating Character Classes and Class Shortcuts in SQL Server RegExPart 4 of Learn RegEx With Louis In part 4 we are starting to get close to knowing enough about Regular Expressions themselves to move towards looking at the different functions in SQL Server (they ae pretty standard functions, but I am very much looking at these in terms of SQL Server. I think there…
-
My Current Favorite Thing in SSMS – Presenter Mode
Read more: My Current Favorite Thing in SSMS – Presenter ModeUpdated to include how you access presenter mode in SSMS 20, if you can’t yet upgrade to 21 for some reason. Based on the name of this feature, you probably think it is a feature that you should only care about if you do presentations. That is so not the case. in fact, I don’t…
-
The Stages of My Layoff Grief – Part 2 – Depression, Acceptance, Fear, and The Future
Read more: The Stages of My Layoff Grief – Part 2 – Depression, Acceptance, Fear, and The FutureThe first phase of my process to get over being laid off was focused on dealing with the shock of life changing drastically in just minutes. You don’t believe it is really happening, you get mad, sad, deny it, and then mad again, etc. Eventually though, it starts to sink in. This is where the…
-
Matching one of a set of characters with SQL Server Regular Expressions
Read more: Matching one of a set of characters with SQL Server Regular ExpressionsPart 3 of Learn RegEx With Louis In this article, we are going to take an initial look at what are referred to as “character classes” or “character sets” in Regular Expressions. They are commonly used when looking for data to be in a certain format. For example: We are going to look at how…
-
Using IS [NOT] DISTINCT FROM to compare data with NULL values
Read more: Using IS [NOT] DISTINCT FROM to compare data with NULL valuesComparing the contents of two values in a relational database can be complicated at times, particularly when the values may have a NULL value. What really makes this more troublesome is that this is not something that a typical language would have. Briefly, it comes down to the fact that in SQL, an uninitialized column…
-
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…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
