A New Word:Wildred
wildred –adj. feeling the haunting solitude of extremely remote places – a clearing in the forest, a windswept field of snow, a rest area in the middle of nowhere...
2023-09-22
17 reads
Creating an Empty Repo in GitHub–#SQLNewBlogger
I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an...
2023-10-13 (first published: 2023-09-20)
248 reads
Product Review: DataVeil
If you’re looking at data masking tools, I recently was able to review the DataVeil solution. Quite simply, getting production data out of non-production environments is still a big...
2023-09-19
67 reads
Are You Protected from Ransomware
There have been many organizations that have become victims of ransomware over the years. Occasionally we hear about some high-profile cases in the news. Most every case I’ve read...
2023-09-19
24 reads
The Last Price Bump for the Data Community Summit
This week the cost of the PASS Data Community Summit jumps up to full price, on Sep 21. This is your last chance to save big, so get someone...
2023-09-18
48 reads
Data Platform SLAs
Database professionals of the world – I have a question. Has your organization defined service level agreements (SLAs) for your data estate? I’m talking specifically the Recovery Point Objective...
2023-10-11 (first published: 2023-09-18)
300 reads
Quick Tip: Taking advantage of Read-Only SQL Server replicas in your C# application
If you happen to be using C# there is a very easy way to set your application up to take advantage of Read-Only replicas.
Using this connection string: (Some portions...
2023-10-09 (first published: 2023-09-18)
1,939 reads
Common Mistakes in SQL Server – Part 1
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
33 reads
Common Mistakes in SQL Server – Part 1
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
507 reads
DataMoshpit!
Today I’m presenting at DataMospit, the most metal conference in the data space! You can download the Sea of Madness bingo card from here: https://github.com/spaghettidba/CodeSamples/raw/master/SQLServerInfernals/InfernalBingo.xlsx The winner will get...
2023-09-16
98 reads
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
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
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