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
2,700 reads
Learn how you can query CosmosDB data from Azure Synapse in this walkthrough.
2020-12-17
6,664 reads
Learn how you can use Polybase technology in Azure Synapse to load data into your warehouse.
2020-07-28
28,022 reads
2020-07-21
486 reads
Learn how to create a Synapse resource and upload data using the COPY command.
2020-07-13
16,285 reads
Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2021-11-26 (first published: 2019-11-04)
15,742 reads
Data classifications in Azure SQL DW entered public preview in March 2019. They allow you to label columns in your data warehouse with their information type and sensitivity level.
2019-05-31
Before writing about pausing (and resuming) Azure SQL Data Warehouse (DW) it makes sense to discuss the architecture of this product. At a high level it involves a control...
The...
2019-05-07
James Serra talks about where you should you clean your data when building a modern data warehouse in Azure.
2019-05-03
This time, we will talk about the competition or alternatives to Azure SQL Data Warehouse.
2018-06-26
549 reads
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Comments posted to this topic are about the item Why Your Index Isn't Being...
Comments posted to this topic are about the item Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers