DataOnWheels

Steve Hughes is the Director of Consulting at 3Cloud. In my current role, I manage the West and Central Data & AI consultant team at 3Cloud. I did a similar role at Pragmatic Works before our merger with 3Cloud. I focus on team development and company growth with this role. In my previous role as a Principal Consultant Lead at Pragmatic Works, I focused on designing solutions for customers on Microsoft technologies including SQL Server, Power Platform, and Azure.

Kristyna Hughes is the Team Lead for BI at GlobalTranz. I have played an instrumental role in moving our company from 3 different reporting platforms to hosting our reporting within Power BI. I provide advice on security structures within the platform, manage the gateways, create and implement design strategies, train, and build reports for both our internal operations committee and external customers. I will also be aiding in embedding Power BI within an unified TMS and ensuring various levels of security are maintained within the embedded reports.

All authors

All authors

Blogs

Goodbye, Microsoft

By

A few years ago I took a new job at Microsoft, working as a...

The SUM of Nothing: #SQLNewBlogger

By

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

I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...

Read the latest Blogs

Forums

Today's AI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Today's AI

Split Large Queries in Athena with a Simple Modulo Trick

By Rahul Gupta

Comments posted to this topic are about the item Split Large Queries in Athena...

Finding Trailing Spaces

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Trailing Spaces

Visit the forum

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        Sally
I 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