Sucharita Das


Analyze Azure Cosmos DB data using Synapse Link and Power BI

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

2021-01-12

702 reads

An Introduction to Azure Cosmos DB

Introduction Azure Cosmos DB is Microsoft's globally distributed, multi-model platform-as-a-service (PaaS) database. Any web, mobile, gaming, and IoT application that needs to handle massive amounts of structured, semi-structured and unstructured data may use Azure Cosmos DB. Guaranteed high availability, high throughput, low latency, and tunable consistency help in reading and writing data at a global […]

3 (3)

2020-11-16

3,205 reads

Incremental Data Loading using Azure Data Factory

Introduction In my last article, Loading data in Azure Synapse Analytics using Azure Data Factory, I discussed the step-by-step process for loading data from an Azure storage account to Azure Synapse SQL through Azure Data Factory (ADF). ADF basics are covered in that article. In this article I will go through the process for the incremental […]

4 (1)

2020-09-24

5,382 reads

An Introduction to Azure Synapse Analytics Workspace

Introduction The Azure Synapse workspace is in preview mode as of July 2020. The workspace brings together enterprise data warehousing and big data analytics. This workspace has the best of the SQL technologies used in enterprise data warehousing, Spark technologies used in big data analytics, and pipelines to orchestrate activities and data movement. Here, I […]

2020-08-24

3,253 reads

Blogs

It’s 2021, so why are you reading this?

By

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....

Daily Coping 20 Jan 2021

By

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

[Coping] Hidden Wounds

By

Through high school and college, I carried deep wounds due to what was going...

Read the latest Blogs

Forums

update using self-join - confirm it looks at old values

By ztoddw

I'm doing an update using a self-join, and just want to confirm something.  If...

Representative Data Challenges

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Representative Data Challenges

The CAST operator in PostgreSQL

By sabyda

Comments posted to this topic are about the item The CAST operator in PostgreSQL

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers