Azure Synapse Analytics February 2023 Updates

by | Feb 28, 2023

Historical monitoring dashboards for Azure Synapse dedicated SQL pools

Deploy rich, interactive monitoring templates for historical monitoring of your Azure Synapse dedicated SQL pool.


Azure Synapse Analytics January Update 2023

Welcome to the January 2023 update for Azure Synapse Analytics!


Disabling Public Network Access in Synapse

Do you get errors like “Fail to load…” or “Error details”?


Strengthen Delta Lake in Synapse with auto maintenance job

In every data engineering program, there is a need for upkeep on a Delta Lake. This blog presents a way to automate such a maintenance process in Synapse Analytics. We introduce a utility that auto detects all Delta Lake files in a Synapse workspace and then auto performs “Optimize” and “Vacuum” operations on those files. This process ensures the performance and size of a Delta Lake remains intact even with regular usage over time.


Spatial analysis in Azure Synapse Analytics with ArcGIS GeoAnalytics Engine

Data is only as valuable as what can be done with it. As data collection from multiple, disparate sources accelerates, companies across all industries have the challenge of finding value amongst diverse datasets.


Azure Synapse analytics (dedicated SQL pool) data modelling best practices

In this article, I will discuss how to physically model an Azure Synapse Analytics data warehouse while migrating from an existing on-premises MPP (Massive Parallel Processing) data warehouse solution like Teradata and Netezza.


Securing your Synapse environment

This blog post will provide an overview of the Synapse security environment focused on Dedicated SQL Pool, Serverless SQL Pool, and Spark.


Enabling Synapse and Azure ML pipeline workflows

As more customers standardize on the Synapse data platform, enabling machine learning workflows through Azure Machine Learning (Azure ML) becomes particularly interesting. This is especially true as more customers look to bring their data engineering and data science practices together and mature capabilities on both sides.


UTF-8 and Japanese collations support for Dedicated SQL pools is now GA!

We are excited to announce that support for UTF-8 and Japanese collations in Azure Synapse Dedicated SQL pools is now generally available!


Azure Synapse MVP Corner – January 2023

Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the “bleeding edge” and have an unstoppable urge to get their hands on new, exciting technologies.


For more information, view the blog here: February 2023 | Microsoft Azure Synapse Analytics Blog | Microsoft Azure Synapse

Contact us today for a more in-depth conversation around Azure Synapse.