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
1,913

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

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

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

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

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

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

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

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

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

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...
4,981

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

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

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

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.
29.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...
6,691

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
nickywong
in Read Only Permissions in Synapse SQL on Mar 08 2024 03:59 AM
Hello I did try your comment to grant "Select" access to the user. It said it was successfully executed under the screenshot below But when I checked the next step, it still shows as 'Null' based on db_datareader under permission _name. was there any restriction I didn't know that's why it didnt wor...
0 Likes
Azobenio
in Create a data solution on Azure Synapse Analytics with Snapshot Serengeti - Part 2 (Analytics) on Feb 17 2024 11:04 AM
Great!
0 Likes