-
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…
-
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…
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 