Azure cosmos DB

SQLServerCentral Article

Quick and Effective Migration Between CosmosDB Collections Using ADF

  • Article

This document aims to explain the process of using ADF (Azure data Factory) to make a copy of a Cosmos DB (Instance A)  collection into a new collection in another Cosmos DB Instance effectively and cost effectively. For example, here is our  Instance A in the Data Explorer: Here is Instance B: We are looking […]

(1)

You rated this post out of 5. Change rating

2024-03-25

1,118 reads

SQLServerCentral Article

You rated this post out of 5. Change rating

2026-02-16 (first published: )

13,024 reads

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.

You rated this post out of 5. Change rating

2021-11-03

2,257 reads

SQLServerCentral Article

Analyze Azure Cosmos DB data using Synapse Link and Power BI

  • Article

Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will […]

You rated this post out of 5. Change rating

2021-01-12

2,700 reads

Technical Article

Powershell Script - Azure cosmos DB(SQL API)

  • Script

Scripts contains 4 following functions. Users can create 3 different script from this for inserting, fetching and deleting a document.
1. Function Generate-MasterKeyAuthorizationSignature - This function is used to create connection to Azure cosmos DB. This function codes were taken from Technet.
2. Function Post-CosmosDb - Insert single document in azure cosmos DB. Same function can be used to perform bulkinsert. This function code was taken from following article. To make it useful i made some modification in it.
(https://www.systemcenterautomation.com/2018/06/cosmos-db-rest-api-powershell/)
3. Function Get-CosmosDocument - Fetch single document from azure cosmos DB. Same function can be used to fetch all documents from Cosmos DB.
4. Function Delete-CosmosDbDocument - Delete single document from cosmos DB. Same function can be used to delete more than one document with some additional codes.

To use any of the function like Post,Get, Delete. you have to comment the other 2 function call. If you are using all 3 functions(Post,Get, Delete), Be cautious while using them.

You rated this post out of 5. Change rating

2020-05-11 (first published: )

3,769 reads

Blogs

From SQL Saturday to Day of Data

By

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters

By

You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...

A New Word: La Guadière

By

la guadière – n. a glint of goodness you notice in something that you...

Read the latest Blogs

Forums

non ascii columns in a utf-8 .txt file

By stan

hi, we couldnt get our upstream data source developers to supply what is sometimes...

PolyBase Trace Flags

By Leo.Miller

Are there any good articles on all the trace flags that are enabled on...

The Data Model Matters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Data Model Matters

Visit the forum

Question of the Day

Running SQLCMD I

I run the SQLCMD utility as follows:

lcmd -S localhost -E
I then type this (the 1> is the prompt):
1> select @@version go
If I hit enter, what happens?

See possible answers