Easy Audit Index Changes
When looking for an easy method to audit Index changes, one of the first technologies to try really should be Extended Events (xevents).
Related Posts:
Monitor Database Offline Events November 15,...
2019-12-27
9 reads
Easy Audit Index Changes
When looking for an easy method to audit Index changes, one of the first technologies to try really should be Extended Events (xevents).
Related Posts:
Implicit Conversion Insights with XE June...
2020-01-07 (first published: 2019-12-27)
423 reads
I’m Speaking at #SQLSatCleveland
I am so excited and honored to have been selected to speak at SQL Saturday Cleveland #930 on February 1, 2020. This will be my second time speaking at...
2019-12-27
24 reads
Azure Synapse Analytics & Power BI concurrency
As a follow-up to my last blog, Azure Synapse Analytics & Power BI performance, I wanted to focus on concurrency when using these two products. A common question I...
2020-01-07 (first published: 2019-12-27)
796 reads
Free SQL Server Training Videos
Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...
2019-12-27
15 reads
Free SQL Server Training Videos
Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...
2019-12-27
156 reads
Merry Christmas
Christmas was this week so nothing technical today, just a simple blog post wishing you and your family blessings and good tidings during this holiday time. May the holidays...
2019-12-27
76 reads
Installing PowerShell for SQL Server – #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. PowerShell is the hot new scripting language for...
2020-01-09 (first published: 2019-12-27)
4,740 reads
Xmas tree in T-SQL
This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...
2019-12-27
15 reads
Xmas tree in T-SQL
This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...
2019-12-27
282 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