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

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

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

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

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
4,893

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

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

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

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

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

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

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

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...
5,858

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

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

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

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

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

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 ...
5,934

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

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

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...
17.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...
8,611

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...
10.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...
5,354

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

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...
14.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.1K

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

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
apttopt
in Getting started with your first Microsoft Azure Synapse Analytics project on Apr 30 2024 10:05 AM
How to migrate synapse analytics workspace with its dedicated SQL pools during cross subscription migration.
0 Likes
CarineLaine
in Extracting SAP data using OData - Part 7 - Delta extraction using SAP Extractors and CDS Views on Mar 26 2024 10:37 AM
Hi Bartosz, You can search for annotations in table DDHEADANNO.
0 Likes
arunkumard805
in Save money and increase performance with intelligent cache for Apache Spark in Azure Synapse on Mar 14 2024 02:31 AM
The introduction of the intelligent cache for Apache Spark in Azure Synapse is a game-changer for data professionals.
1 Likes
letsDoIt_Rocky
in How to start Synapse Pipeline from Rest API on Mar 11 2024 10:29 AM
Hello,We are executing a Synapse pipeline via a T-SQL procedure with Rest API declare @ret as int, @response as nvarchar(max);exec @ret=sp_invoke_external_rest_endpoint @method='POST', @url='https://test-001.dev.azuresynapse.net/pipelines/test/createRun?api-version=2018-06-10', @response=@response o...
0 Likes