Deploy DACPAC to Azure SQL Database
This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Visual Studio.
Deploy DACPAC to Azure SQL Database Read More »
Azure
Create Python Azure function in Visual Studio Code
Azure Functions is a serverless computing service that enables developers to deploy small pieces of code without the need to manage the underlying infrastructure. It supports various programming languages, including .NET, Python, JavaScript, TypeScript, Java, PowerShell, and C#, providing flexibility and versatility for various applications. This article describes how to create Python Azure function in
Create Python Azure function in Visual Studio Code Read More »
Parse JSON in SQL Server
JSON (JavaScript Object Notation) is a lightweight data-interchange format that has become a standard for data exchange in web and database applications. With the rise of JSON’s popularity, SQL Server introduced built-in support for JSON starting with SQL Server 2016. In this article, we will explore how to parse JSON in SQL Server and extract
Parse JSON in SQL Server Read More »
Databricks VACUUM Command
Databricks is a unified big data processing and analytics cloud platform for transforming and processing vast volumes of data. Apache Spark is the building block of Databricks, an in-memory analytics engine for big data and machine learning. In this article, we will see how to use the Databricks VACUUM command to remove unused files from
Databricks VACUUM Command Read More »
A project which specifies SQL Server 2022 or Azure SQL Database Managed Instance as the target platform cannot be published to Microsoft Azure SQL Database v12.
While deploying a DACPAC project to Azure SQL Database using Azure DevOps, you may encounter an error due to specifying SQL Server 2022 as the target platform. The article provides steps to fix this issue by changing the target platform to ‘Microsoft Azure SQL Database’ in Visual Studio and rebuilding the project.
Find Long Running Queries in Azure SQL Database
This post describes how to find long running queries in Azure SQL Database using dynamic management view query.
Find Long Running Queries in Azure SQL Database Read More »
Create user assigned managed identity in Azure
Managed identity in Azure simplifies access management by automatically associating service principals with resources, like creating apps in Microsoft Entra when setting up a data factory. It facilitates secure access to Azure SQL without managing credentials, supporting Azure AD authentication at no extra cost. Azure offers both system-assigned and user-assigned managed identities, with the latter being customizable in the Azure portal. This technique enhances security and ease of management in Azure environments.
Create user assigned managed identity in Azure Read More »
Send Blob Files via Email using Logic Apps
This blog post details how to automate the process of sending blob files from Azure Blob Storage via email using Azure Logic Apps. It covers granting managed identity access to the Logic App, setting up triggers, listing and iterating blob files, and attaching them to emails with Office 365 integration. The workflow, once established, operates on a scheduled recurrence to send updated attachments efficiently.
Send Blob Files via Email using Logic Apps Read More »
Implement Azure SQL Database Deployment CI CD pipeline
In this blog post, we’ll delve into the step-by-step guide of how to implement Azure SQL database Deployment CI CD pipeline using Azure DevOps.
Implement Azure SQL Database Deployment CI CD pipeline Read More »
Access Key Vault from Azure DevOps Pipeline
When setting up deployment pipelines in Azure DevOps, sometimes you need to get secret information stored in Azure Key Vault. This article describes how to access Key Vault from your Azure DevOps Pipelines. It’s all about keeping sensitive data safe and making your deployment process smooth and reliable. Let’s dive in! Pre-requisites:1. Azure DevOps project
Access Key Vault from Azure DevOps Pipeline Read More »