Friday Reading 2017-03-17
As this is being posted I’m on my way up to Dublin Airport to catch my flight to Iceland ready...
2017-03-17
299 reads
Global v Session Trace Flags
I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss...
2017-03-31 (first published: 2017-03-16)
1,943 reads
Check Those Settings
Recently, I was tasked with “enhancing” a third party application. This third party application (TPA) outputs a bunch of files...
2017-03-30 (first published: 2017-03-16)
2,288 reads
Compressed backup errors and TF 3042
Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time...
2017-04-03 (first published: 2017-03-16)
1,676 reads
Return to Birmingham for SQLSaturday Bham 2017!
It's been 2.5 years since I last spoke atSQLSaturday Birmingham, and I'm eager to make a return, this time with...
2017-03-16
291 reads
An Introduction to Containers and Docker
By Chris Gibson
This is the debut blog post of Chris Gibson. Chris is in expert in Microsoft Windows and is...
2017-03-16
1,486 reads
Create a BACPAC–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-15
610 reads
The Livestream Product Launch
SQL in the City Streamed in 2016 was a success, with lots of feedback that people enjoyed the sessions and...
2017-03-15
688 reads
PolyBase use cases clarified
I previously talked about PolyBase and its enhancements (see PASS Summit Announcements: PolyBase enhancements). There is some confusion on PolyBase use...
2017-03-15
628 reads
Webinar – Datacenter Madness – Application Altercation
I hope you all can join me for an upcoming webinar as part of theDatacenter Madness webinar series, presented by...
2017-03-15
327 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