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 »
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 »
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.
Create Elastic Jobs Using Azure Elastic Jobs Manager Read More »
This article describes how to perform Azure Data Factory automation with managed identity and Azure automation account.
Programmatically Start and Stop Azure Data Factory Integration Runtime Read More »
This post explores the concept of transaction batching in SQL Server as a solution to efficiently manage resources and avoid unnecessary rollbacks.
Transaction Batching in SQL Server Read More »
Remove function deletes records from a data source. This article describes how to delete multiple records in PowerApps using Remove function.
Delete multiple records in PowerApps using Remove function Read More »
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 the assembly may not be trusted. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:System.IO.FileLoadException: Could not
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 support most data sources, including on-premises. Once the app is developed, you may want to migrate it to another environment like dev to test. This article describes how to export
Export PowerApps App to another environment Read More »
Power BI offers feature to implement role based access control. This article will describe how to implement RLS in Power BI.
Power BI row level security – Step by step guide Read More »
DACPAC file can be used to deploy database code using CICD tools like Azure DevOps. Learn how to open DACPAC file in Visual Studio.
Open DACPAC File in Visual Studio Read More »
