Starting with Chocolatey
I ran across Chocolatey years ago when Scott Hanselman wrote about it in his power tool list. At the time,...
2017-01-09 (first published: 2017-01-02)
3,226 reads
Presentations & Blogging of 2016 in Review
For the 4th year in a row, I am keeping data on my professional engagements to help the others –
public...
2017-01-02
418 reads
Microsoft Most Valuable Professional – Data Platform
Today, I’m proud to announce that I have been named a Microsoft MVP – Data Platform. This is an exceptional honor and I’m humbled to be included in this...
2017-01-02
21 reads
Microsoft Most Valuable Professional – Data Platform
Today, I’m proud to announce that I have been named a Microsoft MVP – Data Platform. This is an exceptional honor...
2017-01-02
664 reads
Grateful to have been a Microsoft MVP
A couple of weeks ago I received the disappointing but expected news that I wasn’t renewed as a Microsoft Data...
2017-01-02
441 reads
Make Your Application's Name Heard
Odds are, you’ve got more than one application or script accessing your database or SQL Server instance at any given time. You’re probably stacking them on a small number...
2017-01-02
13 reads
Identifying Blocking Chain in SQL Server
HAPPY NEW YEAR 2017!!
I hope you all had a good Christmas and New Year. I always try to review my...
2017-01-01
13,131 reads
2016 – A Year to remember
2016 has undoubtedly been a landmark year in my life. To me it marked my first conscious entry into mid...
2016-12-31
820 reads
Data Channel - Interview 02 - Hamid Fard on SQL Server Memory Capacity Planning
Dear All,
Welcome to the second interview of Data Channel. Very happy and proud to have Mr Hamid Fard, MVP and...
2017-01-06 (first published: 2016-12-31)
1,837 reads
Performance-Oriented SQL Server Development – The Scripts
Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel.
It was a great experience,...
2016-12-30
923 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