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,481

Upgrade to Azure Synapse runtimes for Apache Spark 3.4 & previous runtimes deprecation

eskot on Jun 27 2024 03:38 PM
It is important to stay ahead of the curve and keep services up to date. That's why we encourage all Azure Synapse custo...
3,987

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...
12.9K

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...
13.2K

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...
9,228

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,902

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...
12.7K

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

vysuopys 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...
7,138

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...
12.2K

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...
12.3K

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 ...
8,656

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...
6,217

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...
20.9K

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,742

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...
11.2K

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.
31.6K

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...
8,277

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...
11.4K

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...
8,269

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...
7,073

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,996

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...
38.3K

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 ...
21.7K

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...
21.2K

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...
10.1K

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...
13.4K

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...
6,189

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...
9,377

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...
18.3K

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 ...

Latest Comments

RickySchechter
in Loading CosmosDB and Dataverse data into dedicated SQL pool(DW) using the Synapse link on Sep 10 2024 06:39 AM
Thank you! I am in the exact same boat. I am looking for Fabric "mirroring" support for the final impl. I will try to hold-on on serverless for as long as I can until I am able to migrate. synapse-link and mirroring are the right approach for me, my data gets updated constantly.
0 Likes
A93PTZZ
in Loading CosmosDB and Dataverse data into dedicated SQL pool(DW) using the Synapse link on Sep 10 2024 06:19 AM
Unfortunately I did not find a solution using this particular approach. My end solution ended up being using Azure Data Factory and the CDC feature. I setup a trigger and enabled change detection on the cosmos container. When the changes happen I trigger a dataflow that copies the data from cosmosdb...
0 Likes
RickySchechter
in Loading CosmosDB and Dataverse data into dedicated SQL pool(DW) using the Synapse link on Sep 09 2024 04:26 PM
Hi A93PTZZ I am looking at same scenario, did you figure out a smart way to do this frequently w/o having to copy all data over and over all the time? Thanks
0 Likes
RaviYarramsetti
in Extracting SAP data using OData - Part 1 - The First Extraction on Aug 28 2024 11:06 AM
Hi Bartosz We are trying to establish an OData Connection between Microsoft Fabric and SAP ECC. Your blog has given us a lot of details. In the picture that you provided above - Edit Linked Service. What should we enter Service URL ? and how can we get that Service URL ?
0 Likes
mukeshkpawar
in Automating the Publishing of Workspace Artifacts in Synapse CICD on Aug 09 2024 05:20 PM
This is great and will save significant time and effort. Question -(1) will there a release for each feature branch?(2) release path should be $(System.DefaultWorkingDirectory)/{Build_Alias}/{root folder}, right(3) while specifying specific default branch, it seems it was deploying all the artifacts...
0 Likes