Cumulative Update #2 for SQL Server 2016 SP1
The 2nd cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note...
2017-03-22
1,030 reads
The PASS Executive Committee
I was just reading The PASS Board Guidance Policy . Overall a reasonable document and absolutely worth reading if you’re thinking about...
2017-03-22
399 reads
Here I go again
About two years ago I wrote my first blog post.
About a year ago I paused my blogging activity. That’s when...
2017-03-21
324 reads
C#'s foreach ruined my afternoon
The other afternoon I ran into some nightmarish debugging with the following code:
private static void StartThreads()
{
var values = new List<int>() { 1, 2, 3 };
...
2017-03-21
11 reads
Building a Database DevOps Process at the Data Platform Summit 2017
I’m heading to India this August for the Data Platform Summit 2017. I am honored to have been selected to...
2017-03-21
675 reads
The Pen Cap
This post is for all you up and coming data professionals out there. Over the course of the last week...
2017-03-21
503 reads
Always on\Database Mirroring Automatic Page Repair
A special thanks to Daniel Jones [daniel.jones.0543@gmail.com] for showing up interest and writing informative article for our blog (http://mssqlfun.com/).
Always on\Database...
2017-03-21
1,537 reads
SSIS Articles on SQLShack
Please check out SQLShack.com for three articles on SSIS. I wrote them based on using the SSIS Catalog and Project...
2017-03-21
1,081 reads
Power BI Custom Visuals Class (Module 43 – Gantt)
In this module you will learn how to use the Gantt Power BI Custom Visual. Using the Gantt chart you...
2017-04-04 (first published: 2017-03-21)
2,520 reads
Using Azure CLI to do stuff….
For this post I am going to talk about one of the methods I use to manage my Azure resources.
The...
2017-03-21
333 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