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
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
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
Learn the basics of how to work with objects in Cassandra, a NoSQL database.
2023-12-01
1,327 reads
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
Someone makes a case for using a Document DB rather than a RDBMS. Steve has a few thoughts.
2023-04-24
172 reads
2023-02-06 (first published: 2023-02-01)
3,740 reads
It seems that many people who choose NoSQL platforms still need relational features. Steve speculates on why.
2022-05-18
154 reads
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
609 reads
In this article, we will explore the HTAP capabilities of Cosmos DB. The goal is to derive real-time insights from transactional changes made to Cosmos DB, in a cost-effective manner with minimal overhead. I want the solution to be scalable, reliable and overall simple to maintain.
2021-11-03
2,242 reads
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers