2015-10-05
18 reads
2015-09-18
18 reads
House Price Predictions @ PASS 2015
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
14 reads
House Price Predictions @ PASS 2015
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
18 reads
House Price Predictions @ PASS 2015
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
18 reads
SQL Sentry Grows in the UK and Beyond
Announcing two new UK-based SQL Sentry global technology evangelists. Please help me welcome John Martin and Richard Douglas.
The post SQL Sentry Grows in the UK and Beyond appeared first...
2015-08-07
26 reads
Professional Development – A Recipe for Success
Originally appearing at ForITPros.com. Joe Webb’s father-in-law spent most of his adult life as a cardiologist. That’s a highly specialized and highly technical area in the field of medicine that...
2015-08-06
23 reads
DBTA – StretchDB, a Cool New Feature in vNext SQL Server
Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader,...
2015-08-05
28 reads
Professional Development – What a Difference 60 Years Makes
Originally appearing at ForITPros.com. In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions of concerned Americans. The Soviet government...
2015-07-30
31 reads
DBTA – IT Employers Must Adapt to the Looming DBA Shortage
Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of the findings contained in an intriguing...
2015-07-29
28 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