Overview In this blog post, we’ll delve into the process of configuring Git to manage database objects within a Synapse Dedicated Pool environment (or Azure SQL Database) using Azure Data Studio. We’ll walk through the necessary steps to seamlessly integrate Git version control into your development workflow, allowing for efficient collaboration and tracking of changes across database objects like Tables, Stored Procedures, View and any other SQL objects. By leveraging the powerful capabilities of Azure Data Studio and Git, you can streamline development processes, ensure version consistency ..read more

In this article, we are going to learn about a technique using which you can view the value of the secret variable created inside a Variable Group of Azure DevOps. Introduction Azure DevOps supports us to store secrets within Azure DevOps – Var Groups which could be used with the Pipelines. These secret variables couldn’t be viewed by us manually from the portal. Sometimes, we may want to view the password to perform some administrative activity. In this article, we are going to learn how to create a pipeline that publishes the secret variable created in the Azure DevOps Variable Group. Variab ..read more

In this article, we are going to learn how to connect to Azure DevOps CLI and retrieve the User Info in ALL the Security Groups for each project in the Azure DevOps Organization using PowerShell Introduction One of the Azure DevOps Administrator’s role is to main the inventory of all the users along with their Roles in each of the Azure DevOps project they are associated with. It looks like there is no simple command to retrieve all the users along with their roles in each of projects they are associated with. In this article, we are going to develop a simple PowerShell script which run the Az ..read more

In this article, we are going to learn how to disable the Continuous Integration (auto-trigger) for an YAML based pipeline in Azure DevOps. Introduction One of most important features of Azure DevOps – Pipelines is the ability to invoke the Pipelines automatically when the developers commit their code. When you (as a DevOps engineer) author your YAML pipeline, you also commit your code multiple times especially while you are in development stage which also triggers the Pipelines which you don’t expect as you are still in the development mode. So, it makes sense to disable the automatic trigge ..read more

In this article, we are going to learn how to refer the reusable YAML templates across projects. Introduction Azure DevOps allows us to re-use the Azure DevOps – Pipeline Tasks using YAML Templates. It’s very common that a DevOps Engineer is responsible for developing similar Pipelines in multiple projects. In such scenarios, it makes sense to re-use the YAML Templates in multiple projects by placing the common template in a special Project. Below is how the Project design would look like. Azure DevOps – Tips and Tricks – 19 – How to reuse Templates across Projects-Arch Diagram Create a Templa ..read more

In this article, we are going to learn how to retrieve the permissions assigned to Azure DevOps – Git Repository using Azure DevOps Rest API Prerequisites We are going to use the below tools in order to get the details about Users and the Groups which have access to the Azure DevOps Repository. Azure DevOps Organization & Project Postman Introduction It’s always a daunting job for Azure DevOps administrator to keep track of the access permissions on Azure DevOps resources (ex: Git Repos). In this article, we are going to learn how to get the repo about the Access Permissions for a given ..read more

In this article, we are going to learn how to add IP Address restrictions with in the Azure App Service using ARM Templates. Introduction Azure App Service supports controlling (allow or deny) the access based on IP Addresses. It’s a best practice to use Infrastructure as Code to automate the process. In this article, we are going to learn how to implement the same using Azure Resource Manager Templates. Prerequisites Install Visual Studio Code Azure Resource Manager (ARM) Tools – An extension for Visual Studio Code for authoring ARM Templates Create Azure App Service Plan and App Service Ad ..read more

In this article, we are going to learn how to perform a search in different branches quickly using the Azure DevOps marketplace extension called Code Search. One of the most common requirements is to perform search in your Azure DevOps git repository. For ex: Let’s say, you would like search for a Class name in your git repo, you can type the class name in the Search bar available in the Azure DevOps portal as shown below. Azure DevOps – Tips and Tricks – 16 – How to search for code in branches using Code Search Extension – Search By default, as shown in the above screenshot, Azure DevOps wil ..read more

In this article, we are going to learn about the folders inside the agent that we can use for various scenarios. It’s essential to learn about this folder for building better pipelines. Introduction When authoring Azure DevOps Pipelines, you need to understand the default folder structure that the agent maintains and configures. Azure DevOps Agent supports the below Operating Systems. Windows Linux / Ubuntu macOS In this article, we will focus on Windows and Ubuntu based agents. Let’s try to understand the folder structure by creating a very simple YAML based Azure DevOps Pipeline and add t ..read more

In this article, we will learn how to combine multiple commits into a single commit right within the Azure DevOps portal without writing any git commands. Introduction When multiple team members are contributing towards development of the code, one of the git best practices is to maintain the branch (of main/master) history as clean as possible. The clean history helps everyone understand the sequence of changes done by different team members. At times, when developers work on their stories in their feature branches, it’s a common practice that they do multiple commits and when they are done ..read more