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.
Azure Data Factory Automation with Managed Identity and Automation Account 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 »
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 and Import PowerApps Package 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 »
This article describes how to connect to Azure analysis services from Power BI using Azure Active directory authentication with MFA.
Connect to Azure Analysis Services from Power BI Read More »
This guide will help you find SP related to table in the SQL Server database or Azure SQL database using client tools like SSMS.
Find Stored Procedures related to Table in SQL Server Read More »
This article will provide step-by-step instructions to enable and disable triggers in Azure Data Factory using PowerShell.
Disable and Enable triggers in Azure Data Factory using PowerShell Read More »
