Power BI Custom Visuals Class (Module 19 – Chiclet Slicer)
In this module you will learn how to use the Chiclet Slicer Power BI Custom Visual. The Chiclet Slicer is...
2016-10-04
977 reads
Off Again
It’s another week of travel for me, starting early this morning. This is another crazy trip, and yes, I did...
2016-10-04
405 reads
My SQL Prompt GitHub Repo
Last year I published an article on SQLServerCentral from Guarab Vohra on using SQL Prompt with a VCS. I really...
2016-10-04
650 reads
Future DBA – Big Data -MongoDB 2
In our earlier blog we discussed an introduction to MongoDB. so, how is MongoDB is into BigData, MongoDB has a...
2016-10-04
486 reads
Upcoming Webinars: What’s New in SSRS and MDS 2016
I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features...
2016-10-04
594 reads
SQL 2016 SSMS memory leak?
Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...
2016-10-04
7,271 reads
Detaching corrupt databases
Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL...
2016-10-04
612 reads
PowerShell: Extending Modules – System Parameter measurement
The Microsoft Technet Guru Award (August 2016) winning article – Silver
PowerShell: Extending Modules – System Parameter measurement
PowerShell: Extending Modules – System Parameter measurement
Abstract
The...
2016-10-03
976 reads
Rename a Server with PowerShell
I’m sure many people are experimenting with VMs and SQL Server. If you’re like me, many of you just default...
2016-10-03
1,594 reads
Correlated Datetime Columns
SQL Server is a deep and complex product. There’s always more to learn. For example, I had never heard of...
2016-10-13 (first published: 2016-10-03)
1,812 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