-
T-SQL Tuesday #191 – Your Favorite String Parsing
Read more: T-SQL Tuesday #191 – Your Favorite String ParsingThank you to Steve Jones for this month’s invitation. While this time it was Steve who was late getting it out, to be fair, I didn’t realize that other than the fact that he said it was late. When I got the reminder last week I was on vacation I said “bah, maybe not this month”…
-
Concatenating values as character data including in SQL Server 2025
Read more: Concatenating values as character data including in SQL Server 2025I was looking around for stuff to post about the other day, so I read through the latest What’s new in SQL Server 2025 and I found this: || (String concatenation) Concatenate expressions with expression || expression. My interest was piqued to say the least. Using + to concatenate string data has always had its…
-
SQL Saturday Orlando 2025 Roundup
Read more: SQL Saturday Orlando 2025 RoundupI am a tardy reporter this trip. My positive spin on this tardiness it was that I wanted to stretch the memories out for a bit longer than normal. (My truthful spin is that I was tired from vacation after the conference and then had some things I needed to do first!) This year was…
-
Is the iPad Enough for Remote Work?
Read more: Is the iPad Enough for Remote Work?I am this close to using an iPad as my only roaming device…but not completely. For the past few years, I have used an iPad more and more for my daily work when I am not at my desk with my big monitors. I started this out on a 11-inch Pro device that I used…
-
Feedly Friday – Feeds I Read #11 – Tales from the Field
Read more: Feedly Friday – Feeds I Read #11 – Tales from the FieldFeeds 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…
-
Fun with COUNT aggregate calls
Read more: Fun with COUNT aggregate callsI was reading LinkedIn posts the other day when I saw this blog about what was apparently an interview question about some forms of a COUNT aggregate function This was apparently asked in an interview. What will each of these constructs do in a SQL statement: The correct answers the poster gave were not the…
-
Who is your biggest critic?
Read more: Who is your biggest critic?If there is one thing everyone needs, but doesn’t want, it is criticism. I mean, clearly none of us like it, but we all need it. We need it to keep us humble, and we need it to learn. It is something I have written about before, in this article about how valuable feedback is,…
-
Feedly Friday – Feeds I Read #10 – Kellyn Gorman
Read more: Feedly Friday – Feeds I Read #10 – Kellyn GormanFeeds 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 is…
-
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…


