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

  • 168 Blog Articles
Options
5,941

Azure Synapse Analytics November 2021 Update

saveenr on Nov 30 2021 06:31 PM
Learn about all the new improvements and features in November 2021 update for Azure Synapse Analytics.
3,366

The best practices for organizing Synapse workspaces and lakehouses

JovanPop on Nov 24 2021 11:05 AM
While designing the Lakehouse solution, you should carefully organize your databases and tables based on the underlying ...
1,990

Analyze and contextualize IoT data using Azure Synapse data explorer

cosh23 on Nov 22 2021 01:47 PM
Read this blog if you want to know more about the popular use case of industrial IoT Analytics solutions and how to impl...
2,093

Optimize the types of the columns to improve performance in serverless SQL pool databases

JovanPop on Nov 19 2021 01:00 PM
Minimization for column sizes is one of the most important schema optimizations in serverless SQL pools. In this article...
3,560

New Azure Synapse database templates in public preview

aamerril on Nov 19 2021 09:00 AM
Azure Synapse includes database templates for 5 additional industries, available now in public preview.
2,568

Save time on Apache Spark workloads on Azure Synapse with NVIDIA GPU acceleration

Aria_Jelinek on Nov 12 2021 09:00 AM
Speed up your Apache Spark jobs on Azure Synapse leveraging NVIDIA's RAPIDS acceleration.
1,867

Unlock additional value in your Microsoft data with updates to Azure Synapse Link

Aria_Jelinek on Nov 11 2021 09:00 AM
Learn more about updates to Azure Synapse Link for Microsoft Dataverse and Azure Synapse Link for Azure Cosmos DB, annou...
3,493

Supercharge BI insights with the new Azure Synapse Analytics workspace connector for Power Query

Aria_Jelinek on Nov 10 2021 09:00 AM
Learn more about reporting on all of your Azure Synapse data sources in Power BI with the NEW workspace connector, now i...
4,543

How to query your Delta Lake with Azure Synapse SQL pool

tonytruong23 on Nov 09 2021 09:00 AM
Learn how to query your Delta Lake with serverless SQL pool in Azure Synapse.
3,878

Streamline collaboration and insights with simplified machine learning on Azure Synapse Analytics

Aria_Jelinek on Nov 08 2021 09:00 AM
Learn more about updates for AI + ML in Azure Synapse, announced last week at Ignite 2021.
5,873

Getting started with Azure Synapse data explorer

Manoj Raheja on Nov 04 2021 08:09 AM
Check out these step-by-step technical instructions guild on how to get started with Azure Synapse data explorer
9,326

Introducing Azure Synapse data explorer for log and telemetry analytics

Uri Barash on Nov 03 2021 08:00 AM
To empower every organization to harness the full power of log and telemetry data, we announced yesterday the public pre...
16.7K

Ignite 2021 Announcements: Accelerate time-to-insight with Azure Synapse Analytics

Kaiser-Larsen on Nov 02 2021 09:00 AM
Summary of the latest innovations on Azure Synapse announced at Microsoft Ignite 2021.
3,871

5 Reasons to Join Upcoming Webinar: Build a Unified Analytics Platform with Synapse and Power BI

Kaiser-Larsen on Nov 01 2021 09:00 AM
With Microsoft Ignite starting tomorrow, we want every data professional participating to know about our upcoming webina...
2,157

Reference Architecture: Using Informatica Intelligent Data Management Cloud with Azure Synapse

Peri Rocha on Oct 28 2021 10:04 AM
This document outlines a reference architecture that companies can leverage to deploy a solution with Informatica Intell...
8,796

Azure Synapse Analytics October 2021 Update

saveenr on Oct 22 2021 03:57 PM
Welcome to the Azure Synapse October 2021 update! We’ve got a some key improvements for you this month.  
1,908

Save money and accelerate end-to-end analytics with NEW Azure Synapse Analytics pre-purchase plans

Aria_Jelinek on Oct 14 2021 07:50 AM
  Data teams can lower costs and streamline their analytics workloads by pre-paying for Azure Synapse commit units throu...
2,616

Azure Synapse (Pipelines) for Social Media – YouTube example

Luis_Soares on Sep 22 2021 10:00 AM
  Learn how to use Azure Synapse (pipelines) to get data from social media platforms and store the data for analytics.
3,508

How-To Deploy your Synapse Workspace Artifacts to a Managed VNET Synapse Workspace

RuiCunha on Sep 21 2021 05:34 PM
  This article will demonstrate how you can use the Synapse Workspace Deployment task in Azure DevOps to deploy your Syn...
4,674

Speed up your data workloads with performance updates to Apache Spark 3.1.2 in Azure Synapse

balajisankaran on Sep 21 2021 12:42 PM
Apache Spark 3.1.2 performance in Azure Synapse gets even faster!
4,252

Azure Synapse Analytics RBAC roles are now Generally Available

saveenr on Sep 15 2021 11:30 AM
Azure Synapse RBAC roles that were in preview are now GA.  
4,209

Limitless Analytics Journey with Azure Synapse Analytics

jafilho on Sep 08 2021 02:28 PM
Professional Data Engineers on Code Project have pulled together a series of 18 hands-on articles that will take you on ...
2,909

How to send ideas and suggestions to the Synapse team

saveenr on Aug 19 2021 09:21 AM
  Use Microsoft Q&A to send your ideas and suggestions directly to the Synapse team.
2,612

Synapse serverless shared database and tables access for non sysadmins

Raunak on Aug 16 2021 01:02 AM
  This article talks about how you can provide access to shared tables and databases created in the Synapse SQL Serverle...

Latest Comments

golden83
in Performance Benchmark - Azure Synapse Analytics (Data Warehouse) on Dec 02 2021 07:31 AM
Hi @Sudhir Rawat , We have a synapse implemented for marketing automation and want to understand if it can support below use caseWe have a sales event happening and a microservice is fired for every transaction. Inside the service, we can to fire a select statement to pick the associated Customer fr...
0 Likes
MrAndyCutler
in Azure Synapse Analytics November 2021 Update on Dec 02 2021 02:57 AM
The error handling in OPENROWSET doesn't seem to work when PARSER_VERSION 2.0 is specified when dealing with delimited data: "ERRORFILE_LOCATION is not supported for specified file format." Is this supported when using PARSER_VERSION = 2? Without it we need to use the older version which is slower.
0 Likes
saveenr
in Azure Synapse Analytics November 2021 Update on Dec 01 2021 12:56 AM
Thanks, @isdataninja we've updated the post with the additional industries.
1 Likes
isdataninja
in Azure Synapse Analytics November 2021 Update on Nov 30 2021 07:31 PM
Five more industries now available: AgricultureEnergy & Commodity TradingFreight & LogisticsOil & GasUtilities https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/new-azure-synapse-database-templates-in-public-preview/ba-p/2955431
0 Likes
Sanjay-9_30
in Extracting SAP data using OData - Part 2 - All About Parameters on Nov 25 2021 02:37 PM
Hello @bjarkowskiMSFT Thanks for wonderful article on Odata including part 1, I have been able to extract data from SAP using Odata in Synapse. Would you be able to help me with ways to push filters to API URL's so that it does not return all records? Thanks,Sanjay
0 Likes