Azure cosmos DB

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,063 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,444 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,476 reads

Blogs

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Adding Git LFS Support – #SQLNewBlogger

By

I got this message recently while committing some changes: This post shows my work...

Read the latest Blogs

Forums

Troubleshooting sql issue where multiple sessions are involved

By vsamantha35

Hi All, We have an application that spawns multiple spid's, runs multiple multiple batches...

Best Practice for full backup and transaction log truncation

By anbu678@gmail.com

I am new to SQL Server DB. Could someone please let me know what...

when peers maintain a job rdp'd in they corrupt the job

By stan

Hi, one of my peers prefers to maintain one specific sql agent job after...

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers