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
730 reads
Learn how you can query CosmosDB data from Azure Synapse in this walkthrough.
2020-12-17
1,240 reads
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 […]
2020-11-16
3,261 reads
Learn how you can use Change Tracking to incrementally load data with Azure Data Factory
2020-10-13
3,799 reads
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 […]
2020-09-24
5,562 reads
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,299 reads
Learn how you can use Polybase technology in Azure Synapse to load data into your warehouse.
2020-07-28
4,465 reads
This article shows a basic Azure Data Factory pipeline to load data into Azure Synapse.
2020-07-20
4,062 reads
Learn how to create a Synapse resource and upload data using the COPY command.
2020-07-13
6,358 reads
Details discussion on the different isolation levels available in SQL Server
2019-03-12
48,664 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
When you don't have statistics, what does SQL use to calculate the estimated number...
By Ed Elliott
This is a bit of a longer one, a look at how to do...
I have a requirement whereby testers on ServerA need a copy of the production...
I need to get value portion key to every 3 row on one row...
We have sharepoint as the data source and we have 2 dates created...
Ask SSC