cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure Synapse Analytics Blog
Options
2,744

Interpreting Script activity output json with Azure Data Factory\Synapse analytics

Subashri_Vasu on Jan 31 2024 10:20 PM
Script activity in Azure Data Factory\ Synapse analytics is very helpful to run queries against data sources mentioned h...
7,440

Synapse Connectivity Series Part #4 - Advanced network troubleshooting and network trace analysis

FonsecaSergio on Nov 14 2023 08:00 AM
In this 4th part of connectivity series, we are going deep. On this post we will show how to troubleshoot connectivity i...
11K

Boost your CICD automation for Synapse SQL Serverless by taking advantage of SSDT and SqlPackage CLI

RuiCunha on Sep 14 2023 07:25 AM
In this article I will demonstrate how you can take advantage of thee tools when implementing the CICD for the Azure Syn...
7,815

Metadata-Based Ingestion in Synapse with Delta Lake

madhuvigupta on Jul 19 2023 08:00 AM
Delta Lake as a highly useful format for data Ingestion, Storage and works with multiple compute types in Synapse
5,177

Missing Fields Added to Dedicated SQL pool Diagnostic Settings Logs

jacindaeng on Jun 13 2023 08:00 AM
Nine fields have been added to the Dedicated SQL pool logs and are generally available. These values will provide a more...
11.7K

Using Azure DevOps with Synapse Workspaces to create hot fixes in production environments

Vytas Suopys on May 10 2023 08:00 AM
In this post, I’ll discuss how to deploy a fix from your development Synapse Workspace into a production Synapse Workspa...
6,351

Azure Synapse MVP Corner - March 2023

pawelpotasinski on May 09 2023 09:00 AM
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the c...
10.7K

CI & CD With Azure Synapse Dedicated SQL Pool

pradeeps on May 04 2023 08:00 AM
Automating development practices is hard but we can make it simpler using Version Control, Continuous Integration & Depl...
10.8K

Transforming Your Data Lake: Implementing Slow Change Dimension with Synapse

Liliam_C_Leme on May 03 2023 09:00 AM
In this blog post we will address the following scenario: a customer wants to implement Slow Change Dimension type 2 on ...
7,923

Azure Synapse Analytics April Update 2023

ryanmajidi on May 02 2023 08:00 AM
Welcome to the April 2023 Azure Synapse Analytics Update! This month, we have a new ARM template to deploy Azure Data Ex...
5,511

Extracting relational schema from streaming data containing complex JSON documents

devangshah on Apr 27 2023 08:00 AM
Azure Data Explorer provides operators and functions in Kusto Query Language to extract useful information at scale from...
19.1K

What’s new in SynapseML v0.11

mhamilton723 on Apr 25 2023 10:23 AM
Announcing SynapseML v0.11 We are excited to announce SynapseMl v0.11 with support for ChatGPT, GPT-4, deep learning tra...
6,062

Synapse Database Templates for airlines & travel services plus seven industries are now GA

DataModels on Apr 21 2023 02:00 PM
We’re pleased to announce the general availability of Synapse Database Templates for organizations operating in the Airl...
9,933

Creating a Custom Disaster Recovery Plan for your Synapse Workspace Part 2

fredguis on Apr 21 2023 08:00 AM
Let's explore various options to create a customized DR Plan for Dedicated SQL Pools in greater detail.
30.4K

Unleashing the capabilities of Azure Synapse Analytics for a healthcare customer

PrabhKaur on Apr 07 2023 09:00 AM
This blog post aims to provide you with insights into the best practices for optimizing performance in data ingestion an...
7,386

Essential tips for exporting and cleaning data with Spark

Liliam_C_Leme on Apr 05 2023 08:00 AM
I am creating this post to assist you in developing your solution on top of the data lake by sharing some useful tips. I...
10.6K

Azure Synapse Analytics March Update 2023

ryanmajidi on Apr 04 2023 09:00 AM
Welcome to the Azure Synapse Analytics March 2023 update! This month, we have the General Availability of Multi-Column D...
7,249

Synapse pipelines storage event trigger security deep dive

vengat83MSFT on Apr 03 2023 08:00 AM
ADF and Synapse Pipelines offer a feature that allows pipeline execution to be triggered based on various events, such a...
6,325

Create a data solution on Azure Synapse Analytics with Snapshot Serengeti - Part 2 (Analytics)

Jcardif on Mar 31 2023 08:00 AM
This is the second blog in a four-part series on building an end-to-end data analytics and machine learning solution on ...
6,206

Azure Synapse MVP Corner - February 2023

pawelpotasinski on Mar 28 2023 08:30 AM
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the c...
32K

Create alerts for your Synapse Dedicated SQL Pool

NickSalch on Mar 28 2023 08:00 AM
In this article I will discuss how to configure alerts for you Azure Synapse dedicated SQL pool and provide recommended ...
18.6K

Introduction to Kusto Query Language (KQL)

SuryaJ on Mar 23 2023 09:00 AM
Kusto Query Language (KQL) is a powerful query language to analyse large volumes of structured, semi structured and unst...
18.4K

Multi-Column Distribution for Dedicated SQL pools is now GA!

mariyaali on Mar 22 2023 08:00 AM
Multi-Column Distribution (MCD) for Azure Synapse Dedicated SQL pools is now Generally Available in the latest DW releas...
9,046

Create a Data Solution on Azure Synapse Analytics with Snapshot Serengeti - Part 1

Jcardif on Mar 16 2023 09:10 AM
This will be the first article in a four-part series on building an end-to-end data analytics and machine learning solut...
11.2K

Performance Tuning Synapse Dedicated Pools - Understanding the Query Lifecycle

sarathsasidharan2016 on Mar 16 2023 08:00 AM
Tuning your query to perform at its best needs a certain level of understanding of what goes under the hood. Synapse Ded...
5,573

Azure Synapse Data Explorer enterprise readiness - Part 1: Keeping your data safe

Gilles_LHerault on Mar 09 2023 08:00 AM
We at Microsoft use the Azure Synapse Data Explorer engine (aka: Kusto) to hold our own telemetry. Microsoft also runs o...
8,585

Azure Synapse Analytics February Update 2023

ryanmajidi on Mar 07 2023 09:00 AM
Welcome to Azure Synapse Analytics February update! This month, you’ll find sections on UTF-8 and Japanese Collation sup...
15.5K

Deploying Synapse SQL Serverless objects across environments using SSDT

RuiCunha on Mar 03 2023 08:00 AM
The long-awaited feature for all Synapse CICD fans is here! SqlPackage now supports serverless SQL pools in Extract and ...
11.8K

Creating a custom disaster recovery plan for your Synapse workspace Part 1

fredguis on Mar 02 2023 08:00 AM
Many of our customers have been asking about creating a disaster recovery plan for their Synapse Workspace. In a new blo...

Latest Comments

Prakashraaj
in Deploying Synapse SQL Serverless objects across environments using SSDT on Jun 09 2024 04:30 AM
Hi, I have the following questions,Is it possible to use the above CICD pipelines to extract and publish DACPAC from one Synapse Serverless SQL pool to another Synapse Serverless SQL pool?Does the CICD pipelines support Microsoft Entra ID authentication with MFA, since my Azure synapse supports only...
0 Likes
Dwarren24
in Synapse Connectivity Series Part #3 - Synapse Managed VNET and Managed Private Endpoints on May 22 2024 09:04 AM
Hello Sergio, Thanks for the response. We're connecting to the function using the Azure Functions Synapse Pipeline task, similar to this. We're not using spark notebooks or ADF Can you tell me what I would need to choose in the support portal in order to route this request to your team? Thanks,David...
0 Likes
FonsecaSergio
in Synapse Connectivity Series Part #3 - Synapse Managed VNET and Managed Private Endpoints on May 22 2024 03:40 AM
Hi @Dwarren24First thing as you suspect could be name is to test it Create a spark notebook in this Synapse workspace and run command I shared above, something like below just changing it to your azure function API Note that you should not use URL with "privatelink" you should just use regular Azure...
0 Likes
Dwarren24
in Synapse Connectivity Series Part #3 - Synapse Managed VNET and Managed Private Endpoints on May 21 2024 01:34 PM
@FonsecaSergio Our company is developing some synapse pipelines with a managed private vnet and we need to be able to call some Azure Function Apps that are running in a private vnet in our own subscription via private end points. We've created managed private endpoints within Synapse, but when we a...
0 Likes
jinzo21
in Automating the Publishing of Workspace Artifacts in Synapse CICD on May 15 2024 11:56 AM
We are moving over to use a Federated Managed Indeity ServiceConnection. Do we know when this task will support this?
0 Likes