Does Version Control Scare You
Steve finds a lot of people don't use version control and don't want to learn how to use it.
2025-05-21
224 reads
Version Control Systems (VCS)
This is Why You Use Git for Scripts
Git is a good tool for DBAs and other Operations staff. Today Steve gives you a few reasons why.
2024-02-14
507 reads
Source Control with GIT, Power BI and Microsoft Fabric
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present some challenges related to source control. But it’s finally providing us with a solution to these challenges. Let’s analyse this piece-by-piece.
2023-12-18
Stairway to Database DevOps Level 2: Manage Code with Red Gate SQL Source Control
In this second level of the Stairway to Database DevOps, we learn to use Redgate's SQL Source Control to save and updates changes to objects, as well as tracking data in certain tables.
2023-10-18
1,512 reads
2023-08-28
319 reads
2023-08-25
414 reads
Your First Repo in Azure Data Studio or VS Code
Learn how to get started with Git and avoid the command line by using VS Code or Azure Data Studio.
2022-05-11
5,043 reads
Azure Data Studio and Version Control
This article examines how you can use Azure Data Studio with your git Version Control System.
2022-04-29
8,719 reads
2021-03-26
430 reads
2021-03-19
463 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