Docker Desktop on Windows 10 for SQL Server : Step by Step
This short article explains how to quickly run SQL Server in a Docker container, for both Windows and Linux.
2021-08-13 (first published: 2021-08-11)
40,578 reads
Pauline
- Jobs: DBA
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Alamat BCA KCP Penjernihan Telp:08218520154
WhatsApp CS 628218520153 Jl. Penjernihan I No.23, RT.2/RW.7, Bend. Hilir, Kecamatan Tanah Abang, Kota...
Alamat BCA KCP Tanah Abang 2 Telp:08218520154
WhatsApp CS 628218520154 Jl. Tanah Abang II No.49 & 51, RT.1/RW.4, Petojo Sel., Kecamatan...
ALAMAT BCA KCU GUNSA 45 Telp:08218520154
WhatsApp CS 628218520154 Jl. Gn. Sahari No.45, RT.7/RW.5, Gn. Sahari Utara, Kecamatan Sawah Besar,...
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