Bad Data Can Kill
Bad data can kill. Literally. I’m not talking about the impact of bad data on the bottom line of business,...
2016-05-31 (first published: 2016-05-20)
1,967 reads
Objects dependency check up in SSMS
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many...
2016-05-20
205 reads
SSRS 2005 Bug - Percentage calculated column when Exporting to Excel
Nature of the Issue Faced :- Say you have 3 columns in a tablix/table on the report. There are 3 textboxes...
2016-05-30 (first published: 2016-05-20)
1,132 reads
Speaking about Power BI @ ITPROceed 2016
I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this...
2016-05-19
494 reads
StorSimple Appliance – Part 1 Overview
Last time, I talked about cloud backup and the two different ways of doing it – directly and using StorSimple appliance...
2016-05-27 (first published: 2016-05-19)
1,548 reads
Changing a Computed Column–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-05-27 (first published: 2016-05-19)
2,222 reads
Broken Update With Join
Last month I wrote a post titled Broken Left Join which covered an easy to make mistake that I see...
2016-05-26 (first published: 2016-05-18)
1,805 reads
Migrate from on-prem SQL server to Azure VM IaaS
Hopefully you went through my presentations Should I move my database to the cloud?, Introducing Azure SQL Database and Implement SQL Server on an...
2016-05-26 (first published: 2016-05-18)
3,213 reads
Minion CheckDB Beta
Come meet Codex! We’ve had many of you asking to be part of the Minion CheckDB beta and now is...
2016-05-18
679 reads
Re-Evaluating Best Practices
I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me.
Starting...
2016-05-18
478 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