When working with Azure Data Studio and its support of Jupyter books, you will find there is an option for remote Jupyter books. As shown in the image below,...
2023-03-27 (first published: 2023-03-16)
391 reads
Today’s coping tip is to take three calm breaths at regular intervals during the day. I had to travel recently, crossing time zones and moving between planes, trains, and...
2023-03-16
20 reads
I was planning to write a blog post on how you can find ways to be creative in any technical pursuit. Then, I found out from a friend that...
2023-03-24 (first published: 2023-03-15)
197 reads
Today’s coping tip is to slow down if you find yourself rushing too often. The modern world encourages rushing around. We try to do so many things, get to...
2023-03-15
27 reads
If you’re experiencing delays and errors while working with SQL Server databases due to corrupt database files, you may feel frustrated and helpless. Fortunately, Stellar Repair for MS SQL...
2023-03-15
75 reads
For the past few years, I have been a mentor for FIRST Lego League and now FIRST Robotics Competition at our school. When I was in high school, I...
2023-03-14
28 reads
It’s time for T-SQL Tuesday again, and this time there is an interesting invitation. Damien Jones reached out and wanted to host, so he gets to pick the topic...
2023-03-31 (first published: 2023-03-14)
277 reads
EightKB is a wonderfully ran conference by my friends Mark Wilkinson (T | B), Anthony Nocentino (T | B), Andrew Pruski (T | B), and
The post Call to Action...
2023-03-22 (first published: 2023-03-14)
160 reads
Today’s coping tip is to notice how you speak to yourself and choose to use kind words. I was downtown recently for a few days with my wife, staying...
2023-03-14
14 reads
Od minulého roku jsme spustili náš 4-týdenní Joyful Craftsmen Bootcamp pro budoucí Data Engineers. Jedná se o intenzivní studium přímo u nás v Joyful Craftsmen HUBu, které posouvá datové...
2023-03-14
25 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item 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