SQL Server Parse JSON: OPENJSON, JSON_VALUE and JSON_QUERY
Learn how to parse JSON in SQL Server using OPENJSON, JSON_VALUE, JSON_QUERY and ISJSON, with examples for arrays, nested objects, table columns and SQL Server 2025.
Databricks VACUUM Command: Syntax, Retention, DRY RUN, and Best Practices
Learn how to use the Databricks VACUUM command to remove obsolete Delta Lake data files, preview deletions with DRY RUN, configure retention, and follow safe maintenance practices.
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
Learn how to find long-running queries in Azure SQL Database using DMVs, including query duration, CPU, reads, writes, and SQL text.
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.
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.
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.
Access Key Vault from Azure DevOps Pipeline (YAML & Classic)
Quick answer: Azure DevOps pipelines can retrieve secrets from Azure Key Vault using the AzureKeyVault@2 task or an Azure DevOps variable group linked to Key
How to Create Azure Elastic Jobs with Azure Elastic Jobs Manager
Learn how to create and schedule Azure SQL Elastic Jobs with Azure Elastic Jobs Manager. Configure credentials, target groups, job steps, schedules, and monitoring from Visual Studio or SSMS.
Programmatically Start and Stop Azure Data Factory Integration Runtime with Azure Automation
Learn how to start and stop a managed Azure Data Factory integration runtime from an Azure Automation PowerShell runbook using a system-assigned managed identity.
Transaction Batching in SQL Server: Examples, Best Practices, and Performance
Learn how transaction batching in SQL Server reduces transaction log pressure, limits blocking, and makes large UPDATE and DELETE operations safer and easier to manage.
Delete multiple records in PowerApps using Remove function
Remove function deletes records from a data source. This article describes how to delete multiple records in PowerApps using Remove function.