Praveen Kumar Sreeram's Blog

Azure SQL and Synapse Dedicated Pool – Configuring Git using Azure Data Studio

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, and enhance team productivity within your Synapse Dedicated Pool (and Azure SQL Database) environment. It’s also very important that the Database objects are integrated with Git in order to implement Data Ops.

March 17, 2024 App Service / Azure / Tips & Tricks

Azure App Service Plan – Automating Scaling using Automatic Scaling (Preview)

Introducing the latest advancement in Azure’s App Service Plans: Automatic Scaling (Preview). This awesome feature revolutionizes the scaling process by offering per-app scaling with ease.

March 17, 2024 Azure / Tips & Tricks

Azure Bicep – Refactor common code using User Defined Functions

Learn how to use Bicep’s new feature (in preview currently) called “User Defined Functions” to make deploying your cloud resources on Microsoft Azure easier. This blog will teach you simple way to write code that you can reuse over and over again, making your projects more organized and easier to manage.

February 19, 2023 Azure / Azure Data FActory

Azure Data Factory – How to Retrieve the Latest File in Each Folder

In this article, we are going to learn about retrieving the file based on the Last Modified Date / time in a given folder of Azure Data Lake Gen2.

February 15, 2023 Azure / Azure Data FActory

Azure Data Factory – Return value from a Child Pipeline to a Parent Pipeline

In this article, we are going to learn about returning a value from a child pipeline and consume the same in the Parent Pipeline using a new feature of Set Variable activity called Pipeline return value feature which is currently in preview

February 15, 2023 Azure

Securing Azure Storage Accounts – Restrict Users from Creating Public Blob Access with Azure Policy

In this article, we’ll walk you through the steps to create an Azure Policy that prevents users from creating storage accounts with public blob access.

November 27, 2022 Azure DevOps / Tips & Tricks

Azure DevOps – Tips and Tricks – 23 – How to view the secret variables of a Variable Group

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

November 26, 2022 Azure / Azure DevOps / Tips & Tricks

Azure DevOps – Tips and Tricks – 22 – Import Git repository

In this article, we are going to learn how to import a git repository from one project to another project.

November 19, 2022 Azure DevOps / Tips & Tricks

Azure DevOps – Tips and Tricks 21 – Retrieve all users from All Security Groups in ALL Azure DevOps Projects using Azure DevOps CLI

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

November 16, 2022 Azure DevOps / Tips & Tricks

Azure DevOps – Tips and Tricks 20 – How to disable Continuous Integration on a YAML Pipeline

In this article, we are going to learn how to disable the Continuous Integration (auto-trigger) for an YAML based pipeline in Azure DevOps.