How to configure Managed Identity in Synapse Analytics Workspace?

In data engineering a common challenge is to securely establish communication between different services. By providing an Azure resource identity in Azure AD and using it to obtain Azure Active Directory (Azure AD) tokens, Managed identities (formerly known as Managed Service Identity) remove the need for developers to manage credentials. In this blog, we will … Continue reading How to configure Managed Identity in Synapse Analytics Workspace?

Automating SSIS Build and Deployment with Powershell

Inspired by the DBA tools (https://dbatools.io/) library for automating all things SQL Server DBEngine I created some Powershell Library functions to automate SSIS Build and Deployment. We use this on projects to move SSIS closer to the world of DevOps and that magic “10 deploys a day”. These Powershell functions work well when added to … Continue reading Automating SSIS Build and Deployment with Powershell