SSC Editorial: Early Adopters
I wrote Early Adopters for SQLServerCentral after seeing a comment elsewhere that basically lumped all MVP’s into one category as...
2015-11-25
538 reads
Women in technology
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s...
2015-11-25
633 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some...
2015-12-01 (first published: 2015-11-24)
2,732 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person...
2015-11-24
12 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
50 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
59 reads
SQL Server 2005 End of Support and Business Intelligence
How does the official end of support for SQL Server 2005 affect companies using Reporting Services, Analysis Services and other...
2015-12-02 (first published: 2015-11-24)
1,900 reads
We Are All Responsible
Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):
PASS Anti-Harassment Policy ReminderIt is unfortunate that I have...
2015-11-24
495 reads
Tuesday Morning SQL Break – November 24, 2015
It’s Tuesday time for this week’s one day late blog and twitter round-up for last week. If you haven’t already, follow me...
2015-11-24
537 reads
Why Should Data Professionals Automate?
Take a minute and look around you. Automation is all around you; whether you see it or not processes are...
2015-11-30 (first published: 2015-11-24)
1,513 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