SQL Server & Containers – Part Two
This post follows on from SQL Server & Containers – Part 1 and will go through how to build custom container images.
Since...
2016-11-23
686 reads
Getting Team City working with BitBucket
As a part of building a CI/CD home lab, I set up TeamCity in the past. I plan on using...
2016-11-22
1,071 reads
PASS Summit Announcements: PolyBase enhancements
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-22
285 reads
SQL Server on Linux: Boring
As a concept, SQL Server on Linux is thrilling. Due to this, the OS doesn’t stand in the way of...
2016-11-22
638 reads
Comparing and synchronizing Oracle databases
Applies to: xSQL Oracle Data Compare v1.0 - 2.0
As you may have noticed, most of the articles in this blog focus around scenarios and solutions for databases in Microsoft's...
2016-11-22
19 reads
Comparing and synchronizing Oracle databases
Applies to: xSQL Oracle Data Compare v1.0 - 2.0
As you may have noticed, most of the articles in this blog focus...
2016-11-22
577 reads
SQL Server 2016 service pack 1 is here!
SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here.
Why,...
2016-11-30 (first published: 2016-11-22)
2,443 reads
Power BI Custom Visuals Class (Module 26 – Timeline)
In this module you will learn how to use the Timeline Power BI Custom Visual. The Timeline is a great...
2016-11-29 (first published: 2016-11-22)
2,565 reads
SQL Server on Linux, first observations.
Is this one of those weird food combinations like honey on pizza or salt and pepper on apples that’s going...
2016-11-22
587 reads
Two Weeks to Live! 360 and VSLive Orlando
A short break in speaking, as I haven’t been on stage since Oct 11.
Now it’s two weeks to Live! 360...
2016-11-24 (first published: 2016-11-21)
844 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