Ordering T-SQL Scripts with Git and PowerShell
Learn how you can ensure that scripts are executed in a specific order with Git and PowerShell for use in a Docker container.
2019-05-28
5,047 reads
Containers
Creating Aliases for Docker Commands in Linux
In this article you will learn how to create and use alias commands for Docker, to make Docker's command line experience easier and more productive.
2019-05-20
20,819 reads
Creating Your First SQL Server Docker Container in macOS
The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL Server, however, has been difficult. That changed when Microsoft...
2019-05-13
Creating a custom kubectl plugin to connect to SQL Server in Kubernetes
One of the really cool things about kubectl (pronounced cube control) is the ability to extend it’s functionality with custom plugins. These plugins are simply files named kubectl-xxx dropped...
2019-04-17
Getting Started with Docker
Achilleus has a brief primer on Docker: Now that we know, some basic definitions. It’s time we ask the main question! Why do I care? There are many reasons...
2019-04-15
SSIS, Docker, and Windows Containers, Part 3 – Adding the SSIS Catalog, Attempt 1
In this post, Andy Leonard show his first steps at adding an SSIS Catalog to a container. Spoilers: this attempt fails.
2019-04-05
Managing Kubernetes Resources
Vincent-Philippe Lauzon takes us through some thoughts on how to optimize Kubernetes resource allocation.
2019-04-04
2019-02-25
1,474 reads
2019-02-11 (first published: 2019-02-04)
2,805 reads
2019-01-07
956 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