Skip to main content

Azure Synapse Analytics

Azure Synapse is an analytics service that combines analytics and data warehousing to create what the company calls “the next evolution of Azure SQL Data Warehouse.” You can login to your Azure Portal and search Azure Synapse & you will see “Azure Synapse Analytics (workspaces preview)”. Choose it and create Synapse workspace. Make sure before creating it, you need to register “Microsoft.Synapse” in your subscription.

Features of Azure Synapse Analytics:

Limitless scale GA Preview
Provisioned compute (data warehouse) Available NA
Materialized views & result-set cache Available NA
Workload importance Available NA
Workload isolation Available NA
Serverless data lake exploration NA Available
Powerful insights
Power BI integration NA Available
Azure Machine Learning integration NA Available
Streaming analytics (data warehouse) NA Available
Apache Spark integration NA Available
Unified experience
Hybrid data ingestion NA Available
Azure Synapse Studio NA Available
Instant Clarity
Azure Synapse Link NA Available
Unmatched security
Column- and row-level security Available NA
Dynamic data masking Available NA
Private endpoints Available NA

The predictive analytics using AI and machine learning is a critical element in every enterprise customer digital transformation journey. Current solutions involve creating ETL pipelines which are extremely complex, very expensive and challenging to maintain. These pipelines often got significant delay of hours, days, or even weeks, resulting in decisions being made on still data. The barrier between operational databases and analytical systems has been difficult to all come.
Microsoft announced Synapse Link in Microsoft Build 2020 which is an industry's first Cloud native implementation of hybrid transaction analytical processing. It reduces the complexity of building and operating end-to-end analytical solutions by enabling a simple, intuitive, visual, no code experience.
Synapse Link is removing the barriers between Azure’s operational databases and Synapse Analytics, so enterprises can immediately get value from the data in those databases without going through a data warehouse first.

It allows you to take your Azure Synapse Analytics and point it directly at your operational database and do T-SQL queries against it without having to copy the data to Synapse. This means you can do real-time analytics without impacting your online or operational systems. This is especially important when you are talking about lots of data at big scale.
Currently, Synapse Link is only available with Microsoft’s Cosmos DB but Microsoft is planning to add support for available in Azure SQL, Azure Database for PostgreSQL  and Azure Database for MySQL in the future.
Read Microsoft documentation of Azure Synapse Analytics :


  1. Thanks for sharing this article here about the Azure Synapse Analytics. Your article is very informative and I will share it with my other friends as the information is really very useful. Keep sharing your excellent work. Azure Synapse Analytics

  2. This post is so useful and valuable to increase our knowledge. I am happy that you have shared great info with us. Grateful to you for sharing an article like this. Philippines Import Data


Post a Comment

Thanks for your comment. In case of any concerns, please contact me at

Popular posts from this blog

Comparison between Azure Application Gateway V1 and V2

Microsoft has announced new version of Azure Application Gateway and its Web Application Firewall module (WAF). In this article, we will discuss about the enhancements and new highlights that are available in the new SKUs i.e. Standard_v2 and WAF_v2. Enhancements and new features: Scalability: It allows you to perform scaling of the number of instances on the traffic. Static VIP: The VIP assigned to the Application Gateway can be static which will not change over its lifecycle. Header Rewrite: It allows you to add, remove or update HTTP request and response headers on application gateway. Zone redundancy: It enables application gateway to survive zonal failures which allows increasing the resilience of applications. Improved Performance: Improvement in performance during the provisioning and during the configuration update activities. Cost: V2 SKU may work out to be overall cheaper for you relative to V1 SKU. For more information, refer Microsoft prici

Difference between Azure Front Door Service and Traffic Manager

Azure Front Door Service is Microsoft’s highly available and scalable web application acceleration platform and global HTTP(s) load balancer. Azure Front Door Service supports Dynamic Site Acceleration (DSA), SSL offloading and end to end SSL, Web Application Firewall, cookie-based session affinity, URL path-based routing, free certificates and multiple domain management. In this article, I will compare Azure Front Door to Azure Traffic Manager in terms of performance and functionality. Similarity: Azure Front Door service can be compared to Azure Traffic Manager in a way that this also provides global HTTP load balancing to distribute traffic across different Azure regions, cloud providers or even with your on-premises. Both AFD & Traffic Manager support: Multi-geo redundancy: If one region goes down, traffic routes to the closest region without any intervention. Closest region routing: Traffic is automatically routed to the closest region. Differences: Azu

Install Solr as an Azure App Service

After Sitecore 9.0.2, Solr is a supported search technology for Sitecore Azure PAAS deployments. In this article, we will install SOLR service 8.4.0 in Azure App Service for Sitecore 10. 1. Create Azure App Service Login to Azure and create Azure App service. Make sure Runtime stack should be Java. 2. Download Solr Download Solr 8.4.0 from Extract the files and add the below web.config file in the Solr package. <?xml version="1.0" encoding="UTF-8"?> <configuration>  <system.webServer>      <handlers>      <add  name="httpPlatformHandler"            path="*"            verb="*"            modules="httpPlatformHandler"            resourceType="Unspecified" />    </handlers>    <httpPlatform processPath="%HOME%\site\wwwroot\bin\solr.cmd"        arguments="start -p %HTTP_PLATFORM_PORT%"

Export BACPAC file of SQL database

When you need to create an archive of an Azure SQL database, you can export the database schema and data to a BACPAC file. A BACPAC file can be stored in Azure blob storage or in local storage in an on-premises location and later imported back into Azure SQL Database or into a SQL Server on-premises installation. Let's learn some of the ways to export BACPAC file. Export BACPAC using Azure Portal Open your SQL Database and select Export. Fill the parameters as shown below. Select your storage account container & enter your SQL Server admin login. To check the status of your database export. Open your SQL Database server containing the database being exported. Go to Settings and then click Import/Export history Export BACPAC using SSMS Login Azure SQL Database by SSMS. Right-click the database -> Tasks -> Export Data-tier Application Save the .bacpac file into local disk. Export BACPAC using SQLPackage There is a command line tool that you can also choose to

Azure Machine Learning public preview announcement //Build, May 2021

Azure service updates Azure Machine Learning public preview announcement //Build, May 2021 New feature: Prebuilt Docker images for Inferencing, now in public preview. Click here for more information.