azure sql server vs synapse dedicated sql pool
Azure Synapse Dedicated SQL Pool Azure Synapse Dedicated SQL Pool (Previously Azure SQL Data Warehouse), a massively parallel processing database similar to other columnar-based scale-out database technologies such as Snowflake, Amazon Redshift, and Google BigQuery. To the end-user it is much like a traditional SQL Server, however, behind the scenes it distributes the storage and…
How to Drop a Partition in Azure Synapse Dedicated SQL Pool
Dedicated SQL pool supports partition splitting, merging, and switching. Each of these functions is executed using the ALTER TABLE statement. To delete an existing partition, we need to use “Partition switching” when the table is not empty. If the table is empty, we can merge the empty partitioning using the Merge command. Demo: How to…
Synapse workspace deployment Error- connect ENETUNREACH
Issue: We have installed and added the synapse workspace deployment in our DevOps environment and created a release pipeline to push the ARM template (Development) to the Production environment. But during deployment, we are getting the below error. [error]Encountered with exception:Error: Get workspace location error: Error: connect ENETUNREACH 169.254.169.254:80 Solution: Follow the below steps to…