ASF 018: Mladen Prajdic interview
Introduction Mladen Prajdic is a Data Platform MVP from Slovenia. He’s been professionally programming for over 15 years, developing di?erent...
2019-01-25
192 reads
Blog Posts
Awarded Friend of Redgate – 2019
Friend of Redgate – 2019
I’m excited to announce that I have been named a Friend of Redgate for 2019, my forth year in a row! The program targets influential people in...
2019-01-25
9 reads
Awarded Friend of Redgate – 2019
Friend of Redgate – 2019
I’m excited to announce that I have been named a Friend of Redgate for 2019, my forth year in...
2019-01-25
169 reads
Developing Presence
At SQL Saturday Nashville, I didn’t do a good job explaining the concept of presence. This is in reference to...
2019-01-25 (first published: 2019-01-14)
1,856 reads
Friend of Redgate 2019
This year starts with a good news:
Here is the list of people in the directory.
Stay tuned!
2019-01-25
213 reads
Memory Grants part 6: Memory used in aggregate functions (Min/Max/etc)
So far in this series, I’ve been focusing on the Sort operator. It’s pretty easy for demos since I can...
2019-01-25
697 reads
Microsoft Update Catalog
In today’s world of database administrations, there are a plethora of tools and resources that can be available to utilize...
2019-01-25
381 reads
Speaking at SQLBits 2019
Speaking at SQLBits 2019!
I’m proud to announce that I will be speaking at SQLBits on March 2nd 2019! It’s been a goal of mine to speak at SQLBits for...
2019-01-25
5 reads
Speaking at SQLBits 2019
Speaking at SQLBits 2019!
I’m proud to announce that I will be speaking at SQLBits on March 2nd 2019! It’s been a...
2019-01-25
172 reads
SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!
Watch this week’s video on YouTube.
While most of us strive to make as few mistakes as possible when it comes...
2019-01-25 (first published: 2019-01-15)
2,206 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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