Las Vegas April 2013 UG Meeting
AlwaysOn – Finally, A usable ‘mirror’!
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are...
2013-04-10
865 reads
T-SQL Tuesday #41 - Presenting Opens Doors
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-04-09
962 reads
SQL Server – Generate Calendar using TSQL
Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....
2013-04-16 (first published: 2013-04-09)
13,255 reads
T-SQL Tuesday #41 Becoming a SQL Server “Presenter” GET INVOLVED!
Hello Dear Reader! It’s been a while since I participated in a T-SQL Tuesday, and this month Bob Pusateri (@SQLBob|Blog)...
2013-04-19 (first published: 2013-04-09)
1,359 reads
T-SQL Tuesday – Love For Presenting – #TSQL2sDay
This month, Bob Pusateri (Blog | @SQLBob) is running T-SQL Tuesday on presenting. T-SQL Tuesday is a monthly blogging event where a number...
2013-04-09
571 reads
T-SQL Tuesday #41 – Presenting Comes Full Circle and I Love It!
It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the...
2013-04-09
1,157 reads
TSQL Tuesday #41–Presenting and Loving it?
Well sort of…it took a while.
I’d done some plays and singing at school but my mother made me practice...
2013-04-09
867 reads
T-SQL Tuesday #41 – Presenting and Loving it!
It’s time for our monthly blogging party, commonly known as T-SQL Tuesday. This month, Bob Pusateri is providing the motivation...
2013-04-09
600 reads
Carry On
Sometimes the answer is to keep going.
Forget words, figuring things out, and circumstances. Just keep moving your feet.
~Chuck
"Nothing in the...
2013-04-09
622 reads
T-SQL #41 - Presenting and Loving It!
As I was
exploring the twitter verse, I came across a post with the invitation to this
week’s TSQL
Tuesday #41, and immediately...
2013-04-09
2,314 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