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.
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)
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
Create Elastic Jobs Using Azure Elastic Jobs Manager
Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Similar to the SQL Server Agent job Wizard in SQL Server Management Studio, Azure Elastic Jobs Manager streamlines job deployment oversight with a Visual Studio extension, allowing seamless management from your desktop. This article demonstrates creating elastic jobs using Azure Elastic Jobs Manager, highlighting its resemblance to the SQL Server Agent job in management capabilities.
Programmatically Start and Stop Azure Data Factory Integration Runtime
This article describes how to perform Azure Data Factory automation with managed identity and Azure automation account.
Transaction Batching in SQL Server
This post explores the concept of transaction batching in SQL Server as a solution to efficiently manage resources and avoid unnecessary rollbacks.
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.
An error occurred in the microsoft .net framework while trying to load assembly id 65536 SSIS
Error An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or
Export PowerApps App to another environment
Microsoft PowerApps simplifies app creation with templates, connectors, and third-party apps. Its popularity among developers is due to its ability to perform CRUD operations and
Power BI row level security – Step by step guide
Power BI offers feature to implement role based access control. This article will describe how to implement RLS in Power BI.