f you’ve been working with Azure in the last few years, you’ve noticed there is a relatively new feature that’s supposed to make identity management easier with your Azure solutions: Azure Active Directory (AAD).  This feature does work with Azure SQL Servers and Azure SQL Databases.  But it may not completely plug and play.  In…

Read More SQL Azure and Azure Active Directory

One of the questions I get when teaching others how to use Biml is how do you deal with sensitive information like usernames and passwords in your Biml Solution. No one wants to leave this information in plain text in a solution.  You need access to it while interrogating your sources and destination connections for metadata.…

Read More SSIS Parameters and Sensitive Information

Handling source system metadata changes automatically are pretty easy with BimlScript.  There are several solutions available online check here, here, and here.  Recently, a client brought up a scenario that put a kink in the usual solution.  The client supported multiple tenants, and they wanted to segregate the tasks of handling the metadata changes from…

Read More Biml Solutions and Limited Rights