CICD in Synapse SQL: How to deliver your database objects across multiple environments

In my previous article, I demonstrated how you could take advantage of CI/CD to automate the delivery of your Synapse Workspace artifacts across multiple environments. As a complement to this, I’m adding this new tutorial where you can learn how to com… Continue reading CICD in Synapse SQL: How to deliver your database objects across multiple environments

Potential breaking changes for VM Insights Linux customers – Update your Dependency Agent

Who is impacted?  
All VM Insights customers on Linux running Dependency Agent with versions 9.10.12 or below will be impacted. 
 
What is the impact? 
Dependency Agent for Linux versions 9.10.12 and lower are incompatible with… Continue reading Potential breaking changes for VM Insights Linux customers – Update your Dependency Agent

A new way to troubleshoot out-of-memory errors in the database engine

Introduction
As part of our efforts to improve database engine supportability, we have added a new dynamic management view (DMV), sys.dm_os_out_of_memory_events. It is now available in Azure SQL Database and Azure SQL Managed Instance and will become a… Continue reading A new way to troubleshoot out-of-memory errors in the database engine

Authenticate Standard Logic Apps using OAuth 2.0 Bearer Token

Sometimes we may need our apps to authenticate autonomously without user input. For this we have OAuth 2.0 Bearer Token. We use OAuth 2.0 Bearer Token to authenticate requests on behalf of our apps. For this example, we will authenticate to the Twitter… Continue reading Authenticate Standard Logic Apps using OAuth 2.0 Bearer Token

Azure Application Gateway: 502 error due to backend certificate not whitelisted in the AppGW

If you are using Azure Application Gateway as Layer 7 WAF for End to End SSL connectivity , you might have come across Certificate related issues most of the times. In this article I am going to talk about one most common issue  “backend certifica… Continue reading Azure Application Gateway: 502 error due to backend certificate not whitelisted in the AppGW

Migrate SQL Server databases at scale to Azure using PowerShell / CLI

The Azure SQL Migration extension for Azure Data Studio provides a seamless and robust migration experience to help you migrate your SQL Server databases to Azure. However, if you have multiple databases across multiple SQL Server instances, migrating … Continue reading Migrate SQL Server databases at scale to Azure using PowerShell / CLI