Presenting At OPASS June 15
On Tuesday, June 15, I'm presenting Paging DR Availability, You're Wanted in the Recovery Room at the Orlando SQL Server...
2010-06-10
420 reads
PowerShell I Heart You
PowerShell = Giggity Giggity Goo
Ok so in the last 48 hours I think I’ve fallen madly in love with PowerShell. My...
2010-06-10
920 reads
I’m a Pain
Or maybe I’m misreading that I’m supposed to be helping to alleviate pain. Either way, next Thursday, June 17, I’ll be...
2010-06-10
555 reads
TechEd 2010 – Wednesday
My final day at TechEd. Packed up and checked my bag at the hotel, off to the bus. Noticed that...
2010-06-10
342 reads
2010 Goals – Q2 Review
Another quarter gone, and unfortunately I’m still looking about the same on goal progress. Still looking good on Blog posts...
2010-06-10
1,026 reads
Daily SQL Server 2008 New Feature – Day 20
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-10
408 reads
My Anonymity is Fading
I’ve done a good amount to raise my profile over the years. Not with that intention, but as I’ve tried...
2010-06-10
405 reads
Interesting Case of SSIS Failures
Interesting Case of SSIS Failures
We had an interesting case of SSIS failures recently where the cause ended up being improved...
2010-06-10
1,076 reads
Killer I/O
Here’s a big statement
WHEN WRITING DATABASE QUERIES, 95% OF THE TIME THE BOTTLENECK IS IN THE I/O, not the CPU,...
2010-06-10
982 reads
No Respect for IT
I saw this link posted by Buck Woody (blog | Twitter) and I was a little stunned. This is a profile...
2010-06-10
468 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