2026-09-19
146 reads
Database Weekly
AI Experience Gap that we keep talking about
Earlier this week, I recorded a talk called “AI: The Good, Bad, and the Future.” I talked about some of the good things that have happened with AI and some of the Bad. But what I really wanted to focus on was the future. I think many of us have heard the two letters AI […]
2026-09-12
134 reads
2026-08-22
127 reads
Managing Incidents and Fighting Fires
Managing incidents as a DBA /DB manager and some of the key things you should be doing.
2026-08-08
166 reads
Have you done a Mid year check in?
This Editorial is coming to you during an exciting birthday for the United States. If you are in the US, you are most likely celebrating the 4th of July. This is the 250th anniversary for the US, quite a milestone. I hope that all my US friends are celebrating safely and responsibly. While it is […]
2026-07-04
388 reads
2026-06-27
188 reads
Liability for AI Errors
Who is liable for mistakes made when listening to AI tooling? In at least one case, Steve isn't sure.
2026-06-13
138 reads
Celebrating 30 years of PostgreSQL, A Thank you message
A Thank You message to the original founds of the PostgreSQL project and members of the community that have been working so hard for 30 years.
2026-05-30
301 reads
What Are You Waiting For?
This editorial discusses how to help others take their first step into contributing to the community
2026-05-02
167 reads
2026-04-25
81 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers