What’s the Age Limit for Becoming a DBA?
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted...
2013-10-01
1,186 reads
John Sansom
What’s the Age Limit for Becoming a DBA?
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. Since I only...
2013-10-01
39 reads
Something for the Weekend – SQL Server Links 09/08/13
It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week!
Some of you may have noticed that I’ve...
2013-08-09
1,245 reads
Something for the Weekend – SQL Server Links 09/08/13
It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week! Some of you may have noticed that I’ve been a tad quieter in the SQL community...
2013-08-09
18 reads
SQL Server Crossword #5
When there’s something worth celebrating, such as a birthday or achieving the Microsoft Certified Master (MCM) SQL Server certification, I like...
2013-08-08 (first published: 2013-08-06)
1,465 reads
SQL Server Crossword #5
Test your SQL Server knowledge in a fun and unique way with this exclusive crossword.
2013-08-06
20 reads
The Secret to Keeping Your Cool Like an Experienced Production DBA
Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major...
2013-07-01 (first published: 2013-06-25)
2,882 reads
The Secret to Keeping Your Cool Like an Experienced Production DBA
Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.
In this post I share with you what I...
2013-06-25
23 reads
Your Community, Your Voice, Your Forum
For me, one of the most rewarding things about blogging are the conversations we have together.
The opportunity to connect, share...
2013-05-21
763 reads
Your Community, Your Voice, Your Forum
For me, one of the most rewarding things about blogging are the conversations we have together. The opportunity to connect, share and grow with passionate people from all over...
2013-05-21
11 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