I’m speaking at the first ever SQL Saturday San Antonio on 8/13/16!
San Antonio is such a great city with a lot to see and do, such as the Alamo and the...
2016-07-23
369 reads
Thank You SQL Saturday Sioux Falls!
I just finished giving my SQL Saturday presentation on "Getting Started with Extended Events" at SQLSaturday Sioux Falls. The audience...
2016-07-23
463 reads
Speaking at DevConnections 2016
I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of...
2016-07-22
380 reads
2016-07-22
7 reads
2016-07-22
5 reads
2016-07-22
12 reads
2016-07-22
22 reads
Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Sacramento)
Prakash will walk you through a centralized process using PowerShell where the key information collected, organized and sent via HTML formatted email, provides consolidated view of SQL server along...
2016-07-22
25 reads
Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Sacramento)
Prakash will walk you through a centralized process using PowerShell where the key information collected, organized and sent via HTML...
2016-07-22
435 reads
What’s Database Drift?
The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context...
2016-07-27 (first published: 2016-07-22)
4,417 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
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
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