NoSQL

NoSqlOnSql

  • Article

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 […]

5 (1)

2020-11-02

4,289 reads

The NoSQL Misdirections

  • Article

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 […]

4.46 (13)

2021-06-04 (first published: )

7,643 reads

SQL For Cosmos DB – Tips and Tricks

  • DatabaseWeekly

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

Apache Cassandra Data Modeling and Query Best Practices

  • Article

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

Current State of the NewSQL/NoSQL Cloud Arena

  • Article

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

MongoDB vs. Azure DocumentDB

  • Article

There’s a new kid on the block in the NoSQL world – Azure DocumentDB. Released in preview back in August 2014 and going Generally Available this month, Azure DocumentDB is Microsoft’s initial foray into the increasingly competitive space of non-relational database management systems. Of course there is no better competitor in this space to measure up against than MongoDB. How close does DocumentDB stack up to MongoDB? Are they even close?

2015-05-04

9,575 reads

Blogs

Daily Coping 22 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Why are my permissions missing?

By

You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...

Suggested Topics in Power Virtual Agents

By

Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...

Read the latest Blogs

Forums

Putting a CTE with Subqueries into a stored procedure

By DaveBriCam

Is there a way to place the following code into a SELECT routine in...

Migrating Folder Structure in Report Manager from one SSRS server to another

By rsiem

We are in the process of converting 500+ reports from our old reporting system...

Setting up and using dbt (Data Build Tool) with SQL Server

By David Fundakowski

dbt, or Data Build Tool, is a piece of software that allows analysts to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers