Dancing Robot Goes Rogue
The headline says it all and Steve thinks this could be a problem in the digital world as well.
2026-03-28
111 reads
Database Weekly
Microsoft Security Changes and SQL Server
Windows is changing its security, which will affect SQL Server.
2026-02-14
620 reads
No Defaults Passwords Ever
Steve doesn't see a reason why we should have default passwords on systems ever.
2026-01-17
121 reads
The Microsoft SQL Year in Review
Microsoft gives a year in review from the SQL Server and Azure SQL teams. Steve sees a lot of accomplishments from this past year.
2025-12-20
177 reads
FinOps - the new name for performance tuning
This year I have been speaking with an increasing number of people about FinOps and what it means. Fundamentally, it is all about getting a handle on the cost for our technology spend. When we step back and look at the bigger picture it also has ramifications on corporate Environmental, Social, and Governance (ESG) programs […]
2025-11-29
175 reads
2025-11-15
131 reads
Why Data Modelling Still Matters - More Than Ever
In today’s fast-paced landscape, where agile development and cloud-native platforms dominate, data modelling might seem like a relic of the past.
2025-10-25
273 reads
Planning for tomorrow, today - database migrations
I have been speaking to people about database migrations to the cloud a lot over the last few weeks. One thing that has jumped out at me is that we seem to focus on the process of moving data being the migration rather than one step in a larger process. Many people neglect the discovery […]
2025-09-20
162 reads
2025-09-06
173 reads
Can You Ask for a Raise?
Steve talks a bit about the choice to ask for a raise in the current climate.
2025-06-14
95 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