Switching to Live Search
Steve Ballmer issued a challenge to MVPs a couple weeks ago, asking them to switch to Live Search this week...
2008-12-01
731 reads
Blog Posts
Is the PASS Summit Too Big?
That's the question posed by Kalen Delaney in a write up on SQLMag.com. Is a SQL event of more than...
2008-11-30
1,579 reads
Microsoft Certified Master program – Is This The Answer to Certification Woes?
In the past few years, many people - myself included - have expressed a desire to see the quality of the Microsoft...
2008-11-29
1,715 reads
Grouping Sets
I have given a talk about new data types and T-SQL features to three local groups. I am presenting it...
2008-11-28
2,217 reads
Database Adminstration Scalability
database administration scalabilityI am working on a project that is very successful in terms of its market
share, i.e. product users...
2008-11-27
1,882 reads
Does regulation make data any safer?
Working with healthcare organizations, I am constantly aware of the restrictions my staff and I must abide by according to HIPAA constraints. ...
2008-11-27
1,681 reads
Pumpkin Tossing
One more holiday post. Hope you all enjoyed Thanksgiving and are now enjoying either a quiet and well deserved day...
2008-11-27
1,369 reads
Happy Thanksgiving
I'm cheerfully taking the day off today (and tomorrow too!), and I'm writing this a week in advance as I...
2008-11-26
1,462 reads
Surface Demo
Second try. The video didn’t embed in the previous post. Nor this one. Here's the link
Microsoft Surface Demo
This is from...
2008-11-26
1,439 reads
Surface Possibilities
This is interesting. I’m not sold on Surface, though I did play with one last week in Seattle.
2008-11-26
1,396 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