Latest posts tagged on "PowerShell"

Unleashing the Power of Managed Identity: Running SQL Scripts in Azure DevOps Pipeline

Devops     1018
No Comments    

In this captivating blog post, we delve into the realm of Azure DevOps pipelines and managed identity service connections. Discover the secrets behind seamlessly executing SQL scripts in your pipeline, without the hassle of managing credentials. Follow the step-by-step guide to set up your pipeline, create a managed identity service connection, and configure the necessary tasks. 

Generating an Access Token for Azure SQL Database Using Service Principal with Client Secret using PowerShell

Devops     1201
No Comments    

This blog post explains the process of generating an access token for Azure SQL Database using a service principal with client secret using PowerShell. It provides a clear, step-by-step guide to creating a service principal, assigning the necessary permissions, installing the Azure PowerShell module, authenticating with the service principal, and obtaining the access token. The instructions are concise and easy to follow, enabling users to authenticate and access Azure SQL Database through PowerShell scripting.