DevOps Basics– git Cloning Repos
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-04-21
694 reads
SQL Database File Wise Disk Space Monitoring
As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may...
2017-04-21
1,203 reads
2 Great Courses For Databases Professionals - Deal Of the Week
I received the email from Learning Tree on Wednesday with their weekly offer of courses running in the London Education...
2017-04-21
621 reads
Book Review – The Truthful Art
I’m participating in the #vizBookClub, a great idea by the data visualization community. In short, we read a book about...
2017-04-28 (first published: 2017-04-21)
1,283 reads
Resolution to “Connection Timeout Expired. [Pre-Login] initialization =18090; handshake=14281” error
This blog post is about a SQL Server connection issue that presents itself:
We were building an Availability Group (AG) at...
2017-04-20
434 reads
Microsoft Data Amp event announcements
Yesterday was the Microsoft Data Amp event where a bunch of very exciting announcements were made:
SQL Server vNext CTP 2.0...
2017-04-20
758 reads
What is SQL Server?
I’ve been playing around with YouTube, making some tutorial videos on SQL Server and it’s been a fun process so...
2017-04-20
534 reads
Thoughts about the Microsoft Data Amp Announcements
Microsoft conducted a live event called Microsoft Data Amp to announce a number of key features and releases for SQL...
2017-04-27 (first published: 2017-04-20)
1,588 reads
Presenting 2 sessions @ SQLSaturday (Silicon Valley)
Apr 22nd I will be presenting “Re-Indexing – The quest of ultimate automation” & “Consolidated Essential Performance Health Check using PowerShell” @ SQLSaturday, Silicon...
2017-04-19
397 reads
Using Twitter with VS Code
So today I saw this tweet from Mathias in reply to Stefan and Amanda
That looks cool. Twitter in VS Code, one...
2017-04-28 (first published: 2017-04-19)
1,014 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