NoSQL

SQLServerCentral Article

Azure Cosmos DB – HTAP using Azure Synapse Link

  • Article

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,590 reads

SQLServerCentral Article

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,450 reads

SQLServerCentral Article

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: )

8,004 reads

Technical Article

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

Blogs

Daily Coping 23 Sep 2022

By

Today’s coping tip is to notice what you are feeling without any judgment. Today...

Snowflake – Where is the explain/execution plan?

By

Whatever your database background is you will have heard of an execution / explain...

Daily Coping 22 Sep 2022

By

Today’s coping tip is to ask a trusted friend to tell you what strengths...

Read the latest Blogs

Forums

When use sql graph on sql server 2019 ?

By ahmed_elbarbary.2010

I working on sql server 2019 . i read more about sql graph but...

how to change hard coded dates to ytd please

By asita

Dear Helpers, Below query is working fine giving me what i needed but if...

Couldn't allocate new page for database alert even the Database has free space

By ramana3327

Hi, We have a database. We received the alert Could not allocate new page...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers