Power BI Custom Visuals Class (Module 36 – Box and Whiskers (Brad))
In this module you will learn how to use the Box and Whiskers (Brad) Power BI Custom Visual. This is...
2017-02-07 (first published: 2017-02-03)
1,498 reads
The High Availability Conversation Part 1: Introduction
Hello Dear Reader! Twitter is a fantastic tool if you use SQL Server. It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some...
2017-02-03
16 reads
The High Availability Conversation Part 1: Introduction
Hello Dear Reader! Twitter is a fantastic tool if you use SQL Server. It is a great way to network,...
2017-02-07 (first published: 2017-02-03)
1,869 reads
How the SQL Agent Job schedule_uid broke my heart, and my jobs!
This is something that has caused me some grief in my life as a DBA. I hesitate to call it...
2017-02-03
419 reads
SQL Server vNext
I have been pretty busy recently working with Joe Sack from Microsoft and getting my hands dirty with SQL Server...
2017-02-03
737 reads
Friday Reading 2017-02-03
2017 is trundling along now, this week I’ve been reading…
The GitLab incident report
We’ve all had that moment of “what did...
2017-02-03
326 reads
Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark
(EN)In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.
(DE) In...
2017-02-02
63 reads
Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark
(EN)
In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when...
2017-02-08 (first published: 2017-02-02)
2,091 reads
GitLab for SQL Server Projects
This is the seventh part in the series: SQL Server and Continuous Integration. This post demonstrates the use of GitLab to build...
2017-02-06 (first published: 2017-02-02)
7,854 reads
Using a DMK in TDE
When you setup TDE, you need to create a DMK (Database Master Key) in the master database if one doesn’t...
2017-02-02
798 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