SQL Pivot and Unpivot relational operatots
In this article, we’ll walk-through the SQL Pivot and SQL Unpivot operators and how they can be useful to transpose...
2018-10-15
276 reads
Blog Posts
Starting SSMS with a specific connection and script file
Have you ever wanted SSMS to start and automatically and establish a connection to your DBA \ hub server and have...
2018-10-15 (first published: 2018-10-02)
7,850 reads
Last week reading (2018-10-14)
Hi guys! Not too much this week as I was very busy on #DataRelay tour across UK whole week (relation...
2018-10-14
60 reads
Installing minikube on CentOS
In this blog post, I’ll show you how to install Minikube on CentOS. Minikube is a platform you can use to test kubernetes clusters on your local machine or...
2018-10-13
23 reads
Installing minikube on CentOS
In this blog post, I’ll show you how to install Minikube on CentOS. Minikube is a platform you can use...
2018-10-13
3,141 reads
My Current Training Courses on Pluralsight!
Here’s a run down of the Linux training that I have available on Pluralsight!
Just getting started! Understanding and Using Essential Tools for Enterprise Linux 7 – If you heard...
2018-10-13
7 reads
My Current Training Courses on Pluralsight!
Here’s a run down of the Linux training that I have available on Pluralsight!
Just getting started!
Understanding and Using Essential Tools...
2018-10-13
411 reads
SQL Server on Linux – External Memory Pressure with 2019 CTP2
In this blog post we’re going to revisit how SQL Server on Linux responds to external memory pressure. This is a very long post, and it ends with me...
2018-10-13
13 reads
Azure Cosmos DB Free Trial – walk through of Gremlin API for Graph
After the 2018 Microsoft Ignite event, Microsoft announced a free trial of Azure Cosmos DB. For those who are eager...
2018-10-12 (first published: 2018-10-01)
2,459 reads
I’m Speaking – Denver Dev Day Fall 2018
Denver Dev Day Fall 2018 is a free event organized by volunteers and hosted at the Microsoft campus in the DTC. It’s a full day to learn from industry...
2018-10-12
27 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