Meetings: Have a Point of Focus
Have you ever been in a meeting where the attendees seemed to go down one rabbit trail after another? At...
2018-11-30 (first published: 2018-11-16)
1,834 reads
Blog Posts
My Book Contributions
One of the really super cool things about the SQL community is the frequent opportunity one could have to get involved.
One of my favorite methods of getting involved is...
2018-11-30
12 reads
My Book Contributions
It’s a Wonderful Life
One of the really super cool things about the SQL community is the frequent opportunity one could...
2018-11-30
265 reads
Data Professionals at Work Book
Not only will you encounter some interesting stories, but I believe you will also encounter some interesting insight into some of the contributors for this book: Data Professionals at...
2018-11-29
10 reads
Data Professionals at Work Book
Working as a Data Professional
An old friend Malathi Mahadevan (b | t) asked me one day if I would be interested...
2018-11-29
250 reads
Dealing with multiple AD accounts
To help promote the seperation of duties one of the things my company has done is to divide our permissions...
2018-11-29 (first published: 2018-11-19)
2,400 reads
SQL in the City December 2018
The last 2018 edition of SQL in the City Streamed is coming in a few weeks. You can register today...
2018-11-29
355 reads
Take the State of DevOps Survey
Kendra wrote a nice piece on this the other day, and I agree.
Take the Survey
The data that comes out...
2018-11-29
339 reads
Tips for Attending a SQL Saturday
Matt (blog | twitter) is preparing for his first SQL Saturday presentation next weekend in Washington, DC. He’s asked:
I wanted to get an idea of some good, bad, and...
2018-11-29
21 reads
What is the SQL Server Trustworthy database property?
I ran across an interesting property set in a SQL Server database for a customer, the property is called “Trustworthy”. ...
2018-11-29 (first published: 2018-11-19)
26,735 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