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.