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,312 reads
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
249 reads
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
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,956 reads
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
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,217 reads
The JSON documents that are part of Cosmos DB document collections can be complex with arrays and nesting. In this article, Adam Aspin shows you how to query them with SQL.
2019-06-17
Building on the introduction to the SQL used by Cosmos DB in the first article in the series, here you will learn how to handle some of the more classic challenges that you may face when querying JSON documents. Adam Aspin shows you some of the workarounds that are useful in practice when finding and shaping output data ready for further analysis.
2019-05-22
Organizations have many choices when it comes to database platforms. Choosing the right one for an application should be based on the application’s characteristics and the platform’s features. In this article, Pushpa Sekhara explains why the Apache Cassandra database might be a good choice and how to get the most from it.
2019-03-04
2,398 reads
Choosing the right data platform is not an easy task. Warner Chaves compares the capabilities of the big three Database as a Service (DBaaS) offerings, Microsoft’s Cosmos DB, Google’s Cloud Spanner, and Amazon’s DynamoDB, to help you make the right choice for your application.
2017-12-27
3,064 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
I’ve been running this blog on Hugo for a long time, and like most...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Midea AC offers some of the most energy-efficient, T3-rated inverter air conditioners available in...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers