-
Fun solving a SQL problem (that I will never use in production)
Read more: Fun solving a SQL problem (that I will never use in production)On LinkedIn a few days ago, there was a question that I found interesting about what was purported to be an interview question. The gist was “say you have a set that looks like this: and you need to expand it to be one row based on the value in Quantity, so it should look…
-
Speaking at SQL Saturday Orlando this week!
Read more: Speaking at SQL Saturday Orlando this week!For this Walt Disney World-loving person, SQL Saturday Orlando has always been a natural fit (especially since it is always held in early October, which coincidentally is during the time when Mickey’s Not So Scary Halloween Party is held (guess what my Scenic Route entry will be next week?). The event is currently run by…
-
Sometimes I don’t treat future me all that well
Read more: Sometimes I don’t treat future me all that wellOf all the people in the world who like or dislike me, I think I may be the one that hates me the most. Not in that “self-loathing, I hate everything (or really anything that large) about myself because I am terrible” or something. Nope, just because I often do lazy things in the present…
-
Feedly Friday – Feeds I Read #9 – Glenn Berry’s SQL Server Performance
Read more: Feedly Friday – Feeds I Read #9 – Glenn Berry’s SQL Server PerformanceFeeds I Read Page | Other Feedly Friday Posts Number 9. Number 9. Block that kick. If you know you know exactly what those words mean and may not have even needed prompting. If not, click here. But I digress. Welcome to my continuing series of posts where I am going to highlight one or two feeds…
-
Time Zones and Time Zone Conversions in SQL Server
Read more: Time Zones and Time Zone Conversions in SQL ServerRecently a topic came up at work, and I remember seeing it on Reddit, so you know, that definitely is a sign that I had to write a blog on it. For a lot of people, we typically standardize on a single time zone for our life, and in turn our data. Maybe it is…
-
The Joy(?) of Marketing Myself
Read more: The Joy(?) of Marketing MyselfOne of the definition of irony I found in Google, that was attributed to Oxford languages is: “A literary technique, originally used in Greek tragedy, by which the full significance of a character’s words or actions are clear to the audience or reader although unknown to the character.” Also known as “dramatic irony,” this isn’t…
-
Feedly Friday – Feeds I Read #8 – Andy Leonard
Read more: Feedly Friday – Feeds I Read #8 – Andy LeonardFeeds I Read Page | Other Feedly Friday Posts Welcome to my continuing series of posts where I am going to highlight one or two feeds that 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…
-
And the rest – REGEXP_INSTR, and REGEXP_COUNT
Read more: And the rest – REGEXP_INSTR, and REGEXP_COUNTPart 11 of Learn RegEx With Louis I can’t believe I am finally here. I almost wanted to make this into two blogs, but I decided that they were so similar to the others that it could be done in just one. Much like the Professor and Mary Ann were just as important as the…
-
Do your DBA Skills translate to your life?
Read more: Do your DBA Skills translate to your life?My passion is designing and then working with, databases. At their best, a DBA or database architect/programmer’s career is about is the process of organization, usage, and protection of data assets. But ai wonder how this translates to our personal lives. Data assets share a lot of similarity to any kind of organization. You make…
-
Feedly Friday – Feeds I Read #7 – T-SQL Tuesday
Read more: Feedly Friday – Feeds I Read #7 – T-SQL TuesdayFeeds 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…
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 