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

Azure Synapse Analytics June Update 2022

ryanmajidi on Jun 29 2022 08:00 AM
Welcome to the June 2022 Azure Synapse Analytics update! This month, you will find information about the Azure Synapse S...
1,309

CICD Automation in Synapse Analytics: taking advantage of custom parameters in Workspace Templates

RuiCunha on Jun 21 2022 08:00 AM
When using automated CI/CD in Azure Synapse Analytics, users can take advantage of custom parameters to extend the capab...
1,084

Join us for our first Azure Synapse Influencers Ask the Experts session

ryanmajidi on Jun 15 2022 10:30 AM
I’m pleased to share that registration is now open for our first-ever Azure Synapse Influencers event on June 29, 2022 (...
1,147

Retrieve Azure Synapse role-based access control (RBAC) Information using PowerShell

CharithCaldera on Jun 13 2022 08:00 AM
One of the key use cases that most customers face difficulties while retrieving or assigning the role-based access contr...
1,219

Monitoring Synapse serverless SQL open connections

Liliam_Leme on Jun 07 2022 10:35 AM
    This post has the goal to provide information on how to monitor sessions from any application to serverless SQL.
2,057

Recapping Build 2022

ryanmajidi on Jun 02 2022 10:50 AM
Build 2022 was last week. Checkout all of the excitement we had in store for you.
5,920

Azure Synapse Analytics May Update 2022

ryanmajidi on May 31 2022 08:00 AM
Welcome to the May 2022 update for Azure Synapse Analytics! This month, you’ll find sections on the new Azure Synapse In...
1,876

Data Warehouse Migrations to Dedicated SQL Pools in Azure Synapse Analytics

ajagadish on May 24 2022 03:51 PM
Learn how to easily migrate on-prem data warehouses to dedicated SQL pools in Azure Synapse Analytics Dedicated SQL Pool...
14.8K

Announcing the Public Preview of Azure Synapse Link for SQL

chuckheinzelman on May 24 2022 08:00 AM
Data-driven, quality insights are increasingly critical for companies to stay competitive, and the speed to achieve thos...
2,085

Introducing the Azure Synapse Influencer Program

ryanmajidi on May 18 2022 08:00 AM
We’re pleased to announce the Azure Synapse Influencer program. We’re excited to share this program with the community a...
6,728

Azure Synapse Analytics April Update 2022

ryanmajidi on Apr 27 2022 08:00 AM
Welcome to the April 2022 update for Azure Synapse Analytics! This month, you’ll find a highlight of the Spark 3.2 Publi...
5,963

Announcing General Availability of Database Designer & Database Templates in Azure Synapse Analytics

lakshmi-murthy on Apr 25 2022 11:00 AM
Today, I’m excited to announce the general availability of database designer in Azure Synapse Analytics. The database de...
4,909

Synapse Database Templates General Availability and new Synapse Database Templates for Healthcare

DataModels on Apr 22 2022 10:31 AM
We’re pleased to announce today that Synapse Database Templates are now Generally Available, including availability of n...
1,778

Getting started with your first Microsoft Azure Synapse Analytics project

creyers on Apr 20 2022 11:54 AM
Create your first Azure Synapse workspace to dive deeper into this limitless analytics service that brings big data anal...
3,556

Announcing General Availability of Cross-Subscription Restore for Dedicated SQL Pools

stevehow on Apr 19 2022 10:53 AM
Restore your SQL pool to a different subscription.
4,987

Real-time data ingestion in Synapse SQL dedicated pool at scale

lionelp on Apr 14 2022 11:21 AM
This use case is about streaming data in Synapse SQL dedicated pool leveraging Event Hubs, Stream Analytics and minimize...
10.8K

Azure Synapse Analyzer Report to monitor and improve Azure Synapse SQL Dedicated Pool performance

SanjayRaut76 on Apr 11 2022 12:35 PM
Report focuses on known best practices that Microsoft has identified with Azure Synapse SQL Dedicated Pools.
2,275

CI-CD for Synapse Dedicated SQL Pool using YAML templates

Akshay_Attota on Apr 06 2022 03:15 PM
Purpose of this blog: 1.Defined end-end process of SQL Pool Deployment from Visual studio SSDT code check-in to continuo...
9,111

Azure Synapse Analytics March Update 2022

saveenr on Mar 31 2022 11:00 AM
Welcome to the March 2022 Azure Synapse update! This month, we have SQL, Apache Spark for Synapse, Security, Data integr...
3,566

CICD in Synapse SQL: How to deliver your database objects across multiple environments

RuiCunha on Mar 30 2022 02:01 PM
Azure Synapse Analytics is a product that highly promotes a collaborative environment and with collaboration comes a lot...
2,247

Save money and increase performance with intelligent cache for Apache Spark in Azure Synapse

avinandac on Mar 24 2022 09:00 AM
Data professionals can now save money and increase the overall performance of repeat queries in their Apache Spark in Az...
14.7K

The Data Lakehouse, the Data Warehouse and a Modern Data platform architecture

GregLoxton on Mar 18 2022 03:20 PM
There are two contradictory themes about how to build a modern data platform being proposed to data architects today. Th...
3,148

Best practices for integrating serverless SQL pool with Cosmos DB Analytical store via Synapse Link

JovanPop on Mar 16 2022 03:23 PM
In this post you will find the tips and tricks that would help you to optimize performance of your serverless SQL pool t...
1,576

Set up an Azure-SSIS Integration Runtime (IR) in Azure Synapse Analytics using PowerShell

CharithCaldera on Mar 16 2022 03:21 PM
This article explains the step-by-step to create an Azure SSIS Integration Runtime (IR) in Azure Synapse Analytics using...
3,068

Optimize database schema in serverless SQL pools using QPI library

JovanPop on Mar 09 2022 01:21 PM
Query Performance Insight (QPI) is an open-source library that helps you to discover the potential issues in your databa...
1,816

Implementing Spark posexplode() equivalent in the serverless SQL pool

JovanPop on Mar 04 2022 02:24 PM
The OPENJSON function in Synapse serverless SQL pools transforms a JSON array into the set of rows and can return a colu...
6,284

Azure Synapse Analytics February Update 2022

saveenr on Feb 28 2022 03:15 PM
Welcome to the February 2022 Azure Synapse update! This month, we have SQL and data integration features to share with y...
2,509

Loading CosmosDB and Dataverse data into dedicated SQL pool(DW) using the Synapse link

JovanPop on Feb 02 2022 03:23 PM
Synapse Link in the serverless SQL pools enables you to easily export data from CosmosDB or Dataverse and then you can l...
4,479

Top 5 Quick Tips for Azure Synapse Analytics

saveenr on Feb 01 2022 11:58 AM
To help you kick off the year strong, we wanted to share our Top 5 quick and easy tips from 2021 for optimizing your per...
9,028

Azure Synapse Analytics January Update 2022

saveenr on Jan 26 2022 02:39 PM
Welcome to the Azure Synapse January 2022 update! Our first blog of the year includes newly added database templates, a ...

Latest Comments

_MartinB
in Improve performance of Parquet external tables using new native technology in dedicated SQL pools on Jun 30 2022 07:58 AM
@JovanPop any updates, when the native connector will be GA?
0 Likes
datanick
in The Data Lakehouse, the Data Warehouse and a Modern Data platform architecture on Jun 30 2022 12:22 AM
@Eugene0603 If you are thinking in terms of Synapse you can either think in terms of the "dedicated SQL pool" (former Azure SQL Data Warehouse) or the "serverless SQL pool". Both technologies rely on a Spark cluster in the backend that can easily scale on demand. Of course choosing the right technol...
0 Likes
stevetorchia
in CICD Automation in Synapse Analytics: taking advantage of custom parameters in Workspace Templates on Jun 22 2022 04:58 AM
Great article, thanks!  Is there anything similar in Azure Data Factory?
0 Likes
jimross
in Announcing the Public Preview of Azure Synapse Link for SQL on Jun 20 2022 08:24 AM
This is cool , When will we get the preview on Managed Vnet enabled workspaces?
1 Likes
TheRealScotRoss
in Synapse Workspace Ports and Endpoints on Jun 16 2022 11:03 AM
We had a problem the past couple of weeks with all of our Synapse Workspaces being unable to be connected to from any of our Azure WVD's. On our laptops and even our home PC's they were fully accessible. Turns out that ADO.net port 11004 is now required to connect! Our Firewall logs showed SQL port ...
0 Likes