Watch this week's video on YouTube
Historically it's been difficult to accomplish certain tasks in SQL Server.
Probably the most annoying problem I had to do regularly before SQL Server 2012...
2017-07-18
35 reads
In this module you will learn how to use the Drilldown Player Custom Visual. The Drilldown Player acts like a...
2017-08-01 (first published: 2017-07-18)
1,726 reads
There’s no substitute for mentoring. We’ve heard it before, and in various ways, but I think we tend to largely...
2017-07-18
357 reads
And I’ve got it.
Glenn Berry posted a a link to the MSDN blog and almost immediately a note that the...
2017-08-04 (first published: 2017-07-18)
1,915 reads
I was given the opportunity to do a little online interview. It’s primarily about promotion, but I thought I’d share...
2017-07-18
307 reads
Microsoft have announced the availability of SQL Server 2017 RC1 and I wanted to check it out in a container...
2017-08-02 (first published: 2017-07-18)
2,224 reads
In my previous two blogs – Capture Important Parameters of the SQL Server Replication and Add new articles to existing Transactional Replication...
2017-07-31 (first published: 2017-07-18)
2,817 reads
SQL Server Management Studio (SSMS) for SQL Server 2016 added some interesting enhancements for the vertical scroll bar: Map Mode...
2017-07-17
673 reads
I was playing with containers the other day, reading a Simple Talk article on the topic, and noticed the code...
2017-07-28 (first published: 2017-07-17)
2,018 reads
Last week Aaron Bertrand (b|t) published a post regarding five new PAC Community Ambassadors for SentryOne. I am privileged and...
2017-07-17
334 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Hi, Do you know if there is a way to get more detailed logging...
Comments posted to this topic are about the item Four Rules for Adding AI...
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