Time for a Change
I am ecstatic to say I have joined Denny Cherry and Associates Consulting.
Lone No More
I am happy, excited, and nostalgic...
2017-04-17
363 reads
The Age of Data and Software Development
I am so excited to be a data professional in the modern era. Yeah, 15-20 years ago, it was cool...
2017-04-17
413 reads
What is the “cost” in Cost Threshold for Parallelism?
tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s...
2017-04-17
517 reads
Agent Phases in VSTS Deployment
VSTS (Visual Studio Team Services) continues to grow and change over time. It seems every few months I see some...
2017-04-17
1,675 reads
The Dead Tree Database
“We have all of that information. It’s in a database in my office.” This phrase was music to my ears....
2017-04-27 (first published: 2017-04-17)
1,551 reads
Normal approximation to binomial distribution using T-SQL and R
In the previous post I demonstrated the use of binomial formula to calculate probabilities of events occurring in certain situations....
2017-04-17
1,466 reads
Making VSTS Deployment Changes to Databases without Breaking Your Application
One of the things that I do a lot is demo changes to databases with CI/CD in a DevOps fashion....
2017-04-17
806 reads
DBA 101: Comparing two SQL plans
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a...
2017-04-18 (first published: 2017-04-14)
2,051 reads
Way Off-topic: Why cutting the cord was right for me
FYI: This one is way off topic so don’t expect to find any fancy SQL tips here.
I did it. I...
2017-04-14
497 reads
Power BI and Data Security – Row Level Security (RLS)
As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern....
2017-04-25 (first published: 2017-04-14)
1,948 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