synapse sql
47 TopicsSynapse – Data Lake vs. Delta Lake vs. Data Lakehouse
As a data engineer, we often hear terms like Data Lake, Delta Lake, and Data Lakehouse, which we might be confusing at times. In this blog we’ll demystify these terms and talk about the differences of each of the technologies and concepts, along with scenarios of usage for each.52KViews14likes0CommentsCreate alerts for your Synapse Dedicated SQL Pool
In this article I will discuss how to configure alerts for you Azure Synapse dedicated SQL pool and provide recommended alerts to get you started. Enabling alerts allows you to detect workload issues sooner allowing you to take action earlier to minimize end-user impact.50KViews3likes4CommentsUnleashing the capabilities of Azure Synapse Analytics for a healthcare customer
This blog post aims to provide you with insights into the best practices for optimizing performance in data ingestion and transformation. You will learn how to efficiently use available resources, compute capacity, and workload management in Azure Synapse Analytics workspace. While the solution discussed in this blog pertains to a healthcare industry customer, the optimization techniques presented here are applicable to other industries as well.39KViews5likes6CommentsUnderstand Synapse dedicated SQL pool (formerly SQL DW) and Serverless SQL pool
What is the difference between Synapse dedicated SQL pool (formerly SQL DW) and Serverless SQL pool? Which one should you choose for your business? This post explains the basic concepts of SQL Dedicated Pool and Serverless SQL Pool, how they work and how to use them based on your business needs.32KViews6likes2CommentsMulti-Column Distribution for Dedicated SQL pools is now GA!
Multi-Column Distribution (MCD) for Azure Synapse Dedicated SQL pools is now Generally Available in the latest DW release! MCD is highly desirable for easing migrations, promotes faster query performance and reduces data skew.24KViews8likes14CommentsDeploying Synapse SQL Serverless objects across environments using SSDT
The long-awaited feature for all Synapse CICD fans is here! SqlPackage now supports serverless SQL pools in Extract and Publish operations. In this article, I will demonstrate how you can run this utility in a DevOps pipeline to replicate your SQL serverless objects across different environments.20KViews6likes13Comments