synapse cse
32 TopicsSynapse pipelines storage event trigger security deep dive
ADF and Synapse Pipelines offer a feature that allows pipeline execution to be triggered based on various events, such as storage blob creation or deletion. This can be used by customers to implement event-driven pipeline orchestration. In this blog post, we will address some common security questions and challenges that may arise during storage event trigger creation.11KViews3likes4CommentsCreate 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.50KViews3likes4CommentsIntroduction to Kusto Query Language (KQL)
Kusto Query Language (KQL) is a powerful query language to analyse large volumes of structured, semi structured and unstructured (Free Text) data. It has inbuilt operators and functions that lets you analyse data to find trends, patterns, anomalies, create forecasting, and machine learning.30KViews5likes3CommentsPerformance Tuning Synapse Dedicated Pools - Understanding the Query Lifecycle
Tuning your query to perform at its best needs a certain level of understanding of what goes under the hood. Synapse Dedicated Pool is an MPP engine built up of several services which work together to deliver superior performance.Azure Synapse Data Explorer enterprise readiness - Part 1: Keeping your data safe
We at Microsoft use the Azure Synapse Data Explorer engine (aka: Kusto) to hold our own telemetry. Microsoft also runs on trust so we are serious about data protection and privacy. Let's dive in and see how Azure Synapse Data Explorer keeps your data safe.6.5KViews2likes0CommentsCreating a custom disaster recovery plan for your Synapse workspace Part 1
Many of our customers have been asking about creating a disaster recovery plan for their Synapse Workspace. In a new blog series, we will cover the basics of disaster recovery and business continuity, discussing available options and custom solutions.16KViews6likes1CommentAzure Synapse analytics (dedicated SQL pool) data modelling best practices
In this article, I will discuss how to physically model an Azure Synapse Analytics data warehouse while migrating from an existing on-premises MPP (Massive Parallel Processing) data warehouse solution like Teradata and Netezza.13KViews10likes6Comments