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
154 reads
NoSQL
2023-02-06 (first published: 2023-02-01)
2,887 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
137 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
325 reads
Azure Cosmos DB – HTAP using Azure Synapse Link
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
1,980 reads
Where Does NoSQL work well?
NoSQL was hyped as the way to replace your RDBMS and achieve incredible performance at scale. It does work well, but it hasn't replaced most RDBMSes. Steve has a few thoughts on this topic.
2021-06-28
234 reads
How to choose between SQL and NoSQL databases
Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose between SQL and NoSQL databases.
2021-05-19
NoSqlOnSql
Introduction NoSqlOnSql is a strict syntactical superset of SQL; it adds NoSQL document-oriented capabilities to the SQL language. For this, it uses uses JSON-like documents, integrating them into the normal flow of SQL statements. NoSqlOnSql is based on augmenting a SQL database to support NoSQL features without any kernel changes. In this sense it is […]
2020-11-02
4,592 reads
Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key
As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design considerations for porting a SQL Server schema to Cassandra. The first article explains the Cassandra primary key.
2020-01-10
The NoSQL Misdirections
Editorial Note: This is a republish, in memory of Mike who passed away too soon. You can see his memorial at sqlmemorial.org. Recently I have been working with a colleague who is doing a bit of a side projects outside of work. He's trying to expand his skillset using a pet project at home. I encouraged […]
2021-06-04 (first published: 2019-09-02)
8,080 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Error message in launching web service url in sql report server
I am getting the following error when I launch web service url in sql...
Report server login issue
Trying to deploy reports in visual studio 2022, reporting service login is asking for...
Opening and closing with date filter is not giving me correctly output
I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value will be...
Ask SSC