SQLRelay Reading - Build a CI Pipeline in 55 Minutes Talk
I had a lot of fun yesterday presenting my talk on how to go from not having your database in...
2015-10-09
54 reads
SQLRelay Reading - Build a CI Pipeline in 55 Minutes Talk
I had a lot of fun yesterday presenting my talk on how to go from not having your database in...
2015-10-09
51 reads
Excel Tip #29: Forcing Slicers to Filter Each Other when Using CUBE Functions
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-10-09
945 reads
How do you choose a source control system for your SQL Server database
If you already have a source code repository for your app code or other databases or you have another team that uses source control then just use theirs.
If you...
2015-10-09
12 reads
SQLRelay Reading - Build a CI Pipeline in 55 Minutes Talk
I had a lot of fun yesterday presenting my talk on how to go from not having your database in version control to deploying to a CI database, running...
2015-10-09
16 reads
Thank You Community
All I can say is, “Wow…Thank you!”. I won a seat on the PASS Board of Directors and it’s very...
2015-10-09
440 reads
Deployed Target Metadata with PoSH
This article shows a deeper dive that will show how to expose the Deployed Target Metadata with PoSH and familiarity with this powerful tool.
Related Posts:
PowerShell to Backup XE Session...
2015-10-09
9 reads
Deployed Target Metadata with PoSH
Having just covered the methods to discover the metadata for a deployed session including the details about the session settings,...
2015-10-09
567 reads
Untrusted Check Constraints
Check constraints are useful for more than just verifying the data that goes into your tables. The query optimizer can...
2015-10-09
1,296 reads
SQL Server Contracting – The first 14 months (or so)
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem...
2015-10-09
28 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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