First Things First Thank you to everyone who attended my session “Answering the Automator’s Call with Automation.” My slide deck and demo code are now available on my Github.....
2023-10-16 (first published: 2023-10-15)
79 reads
Thanks to everyone who came to my sessions at SQL Saturday Boston 2023. I’ve added the decks to the schedule, so you can click my session and will see...
2023-10-14
66 reads
harmonoia – n. an itchy sense of dread when life feels just a hint too peaceful – when everyone seems to get along suspiciously well, with an eerie stillness...
2023-10-13
53 reads
You can find the slides for the session that I gave with Johan at dataMinds Connect 2023 at GitHub. As usual, the event was amazing. A lot of great...
2023-10-12
39 reads
Microsoft Fabric is an awesome product that has now been in public preview for five months. If you are not familiar with it, check out my recent video where...
2023-10-11
250 reads
In the fast-paced world of IT, where trends like DevOps and Infrastructure as Code (IaC) dominate the landscape, the concepts of Reliability and Observability have seamlessly woven themselves into...
2023-10-25 (first published: 2023-10-10)
529 reads
I left home last Tuesday for work, heading to New Jersey for work. Over the weekend, I took a side trip to see my daughter play volleyball at university,...
2023-10-09
49 reads
As many of you know, I was diagnosed with ALS or Lou Gehrig’s disease a couple of years ago. Since then, I have 9 made it a personal mission...
2023-10-09
57 reads
Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your...
2023-10-09
37 reads
Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your...
2023-10-23 (first published: 2023-10-09)
951 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item 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