An Eventual Consistency Scam
Steve uncovers a scam that relies on data not being consistent between two systems.
2026-08-21
152 reads
NoSQL / NewSQL
Consistency and Concurrency in NewSQL Database Systems
Companies today require database systems that are reliable and capable of efficiently handling large volumes of data and numerous transactions. Traditional relational databases, once the foundation of data management, often struggle to meet these modern demands, leading to delays and program slowdowns. In response, NewSQL databases, a new class of SQL systems, has emerged.
2024-10-30
Deleting Documents from a MongoDB Collection
So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a MongoDB collection. This article continues that discussion by explaining how to use MongoDB Shell to delete documents from a collection.
2024-07-19
Introducing the MongoDB Document
MongoDB is a document database. As such, the data is stored as individual documents. A document is a data structure made up of one or more field/value pairs.
2024-01-19
Getting Started with DDL statements of Cassandra Query Language
Learn the basics of how to work with objects in Cassandra, a NoSQL database.
2023-12-01
1,412 reads
Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points.
Is MongoDB in use within your organization? The Flyway development team is adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey.
2023-11-17
A Case for Document Storage
Someone makes a case for using a Document DB rather than a RDBMS. Steve has a few thoughts.
2023-04-24
199 reads
2023-02-06 (first published: 2023-02-01)
3,812 reads
The General Database Platform
It seems that many people who choose NoSQL platforms still need relational features. Steve speculates on why.
2022-05-18
187 reads
The NoSQL Rise and Fall
The NoSQL class of databases were very popular for awhile, but it seems many companies are sticking with an RDBMS in many cases.
2022-02-16
648 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