SSMSDeploy Now Available!
I have finished my website, done all my recompilations, checked all my settings, and finally SSMSDeploy is on the internet,...
2011-01-19
611 reads
SSMSDeploy Demo #2 - new features
I've made some changes to the addin, adding some new features:
Comments: You can now add a comment to your request....
2011-01-15
615 reads
SSMSDeploy will be available, with source, for donation
After much um-ing and ah-ing I have decided to release my addin, with source code, under the GNU GPL.
I've also...
2011-01-15
572 reads
SSMS Addin Wrapper - Source Code and Usage
Code First, KTHX!
Here, as promised, is the source code for the SSMS wrapper.
Introduction
My apologies for the brief delay on this....
2011-01-10
2,388 reads
Updated SSMSDeploy Demo Video
This is just a quick note before I head off for work that I have made a new demo video...
2011-01-10
645 reads
SSMSDeploy - Demo Video Available!
Updates
1) I have discovered that there was already a tool called SQL Deploy, so I have renamed my addin to...
2011-01-09
595 reads
SSMS addin (and wrapper)
So I mentioned I'd been working on an SSMS addin. What I didn't mention was that I've also been working...
2011-01-04
1,423 reads
Easy CDC part 2: Automating a Quick Initial Load, and Some Gotchas
Introduction
A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database....
2011-01-01
1,340 reads
Interlude: SSMS tips
Introduction
I know I said I was going to add more information about the CDC system in this post, but I...
2010-12-23
1,373 reads
Relational Types.
As I try to drag my team (sometimes with resistance, sometimes with pleasure) into the world of relational principles, I...
2010-12-23
1,083 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