Quick #SQLPrompt Tips – Expanding Wildcards
I tend to try and get code on the screen quickly and then start to remove things. I’m a visual...
2016-09-15
618 reads
#SQLSpeaking this Fall!
I have some great speaking dates coming up this Fall - here is the list:
--
First - the big one. I am honored...
2016-09-15
428 reads
Emojis in SQL Server
I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures...
2016-09-15
1,313 reads
Power BI Custom Visuals Class (Module 16 – Bubble)
In this module you will learn how to use the Bubble chart Power BI Custom Visual. The Bubble chart allows...
2016-09-22 (first published: 2016-09-15)
1,538 reads
Great Value IT Training - Awesome ITIL offers
This week's Great Value IT Offers are in. If you want to your ITIL learning on this autumn we have...
2016-09-15
384 reads
Sql Server - Detecting and Monitoring Memory Pressure
Introduction - Detecting and Monitoring Memory Pressure
I will be writing this article in four parts because this
topic is huge and amount...
2016-09-15
484 reads
More PowerShell for the Azure World
The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use...
2016-09-15
498 reads
Future DBA part 2
I do not say you should be expert in other technologies but you should be aware of what it is...
2016-09-15
390 reads
The SQL Server Community Collaborative GitHub Organisation is born
My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called...
2016-09-14
780 reads
This Week In Data – Episode 4 (What is Slack?)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-09-14
517 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