This is a company that practises what they preach
How good is a company at engaging with their user base? Obviously when things are going great then it’s wins...
2018-10-22
966 reads
Blog Posts
Time for SQL in the City Summit–Chicago
This week is the last live SQL in the City Summit this year. It’s this Friday at the Microsoft office...
2018-10-22
751 reads
Upcoming #SQLChat on Making the Most of Conferences
This month’s #SQLChat is hosted by Rie Irish (twitter | blog). It’s a timely topic: Making the Most of Conferences. With...
2018-10-22
220 reads
Last week reading (2018-10-21)
DevOps Terms – and Why They Matter to Database Specialists Find out what is Scrum, Continuous Deployment, TDD and others from...
2018-10-21
76 reads
Notes from SQLSaturday #801 (2018)
We wrapped up our 12th SQLSaturday here in Orlando two weeks ago. Overall things went well. Registration was just a...
2018-10-20
263 reads
SQL Server 2019
I have written about 2017 here, Last month at Microsoft Ignite FL on September 2018, Microsoft announce they are going to...
2018-10-20
280 reads
Sharding: Horizontal Scaling in Azure SQL Database
David has produced a talk all about Sharding. Or if you prefer horizontally scaling your Azure SQL database.
You can view...
2018-10-19 (first published: 2018-10-04)
2,740 reads
SQL Server – Reading BACPAC Files
If you have been reading my blog for a while now you would know that a common technique to move...
2018-10-19
278 reads
T-SQL Tuesday 107 – Viral Demo
For this month’s T-SQL Tuesday. Jeff Mlakar invites to talk about “a project you worked on or were impacted by...
2018-10-19 (first published: 2018-10-09)
1,877 reads
Contextual View Part II or how to hide sensitive data
In this article I continue to explore the ways to secure the data via contextual views and describe the technique...
2018-10-18
551 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