Azure Synapse Analytics March 2023 Updates

by | Mar 30, 2023

Using OpenAI GPT in Synapse Analytics

Azure OpenAI hardly needs an introduction, but for those who managed to evade all tech new lately, let me give you a brief overview. Azure OpenAI is a suite of natural language processing (NLP) models developed by OpenAI. The models can be used in a very wide range of applications, including text generation, summarization and translation. Microsoft offers Azure OpenAI as an Azure Cognitive Service, which means that it comes with the same feature set as existing cognitive services. It is available as an API, and it supports private connectivity and Azure RBAC. In this post I’ll demonstrate you how to access Azure OpenAI’s GPT models from within Synapse Spark.


Azure Synapse Spark Notebook – Unit Testing

In this blog post, we will cover how to test and create unit test cases for Spark jobs developed using Synapse Notebook.


Creating a custom disaster recovery plan for your Synapse workspace Part 1

Many of our customers have been asking about creating a disaster recovery plan for their Synapse Workspace. In a new blog series, we will cover the basics of disaster recovery and business continuity, discussing available options and custom solutions.


Deploying Synapse SQL Serverless objects across environments using SSDT

At Microsoft, we love to hear your voice! The Synapse community asked for SqlPackage’s long-awaited support for Azure Synapse Analytics Serverless SQL Pools, and we delivered! Now you can automate the deployment of your Synapse serverless SQL objects along with your Synapse dedicated SQL objects!


Azure Synapse Analytics February Update 2023

Welcome to Azure Synapse Analytics February update! This month, you’ll find sections on UTF-8 and Japanese Collation support, the General Availability of Spark 3.3, and other features in SQL, Spark, and Data Integration. Read on for more details and check out our video!


Azure Synapse Data Explorer enterprise readiness – Part 1: Keeping your data safe

It’s one thing to be a great Azure Service, it’s another to also be easy and efficient to manage. This is part one of our “Enterprise readiness” series for Azure Synapse Data Explorer. We will focus on how customers can leverage enterprise ready features to keep their data safe. Part two will cover how we help customers “keep the lights on” (i.e., Running operation costs) for their Azure Synapse Data Explorer investment while not overburdening their existing operational load.


Performance Tuning Synapse Dedicated Pools – Understanding the Query Lifecycle

Synapse Dedicated pools have been battle tested at enterprise customers across the globe. We deal with data in the magnitude of PetaBytes. Synapse can provide you with the scale of the cloud and the high performance required for your enterprise-grade requirements. The key to maximizing your performance is to follow best practices.


Create a Data Solution on Azure Synapse Analytics with Snapshot Serengeti – Part 1

This will be the first article in a four-part series on building an end-to-end data analytics and machine learning solution on Azure Synapse Analytics.


Multi-Column Distribution for Dedicated SQL pools is now GA!

We are excited to announce that Multi-Column Distribution (MCD) for Azure Synapse Dedicated SQL pools is now Generally Available in the latest DW release! MCD is highly desirable for easing migrations, promotes faster query performance and reduces data skew.


Introduction to Kusto Query Language (KQL)

Kusto Query Language (KQL) is a powerful query language to analyse large volumes of structured, semi structured and unstructured (Free Text) data. It has inbuilt operators and functions that lets you analyse data to find trends, patterns, anomalies, create forecasting, and machine learning. Along with Azure Synapse Data Explorer, other Azure native services like Log Analytics, Azure Monitor and App Insights also use KQL to query data. This blog will be an introduction to KQL and its usage in Azure Synapse Data Explorer.


Create alerts for your Synapse Dedicated SQL Pool

In this article, I will discuss how to configure alerts for you Azure Synapse dedicated SQL pool and provide recommended alerts to get you started. Enabling alerts allows you to detect workload issues sooner allowing you to take action earlier to minimize end-user impact.


Azure Synapse MVP Corner – February 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. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems.


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

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