Lesson Learned #192: MSIS7068-Access denied error message connecting to Azure SQL Database using AAD

Today, we worked on a case that our customer faced the following error message: “MSIS7068: Access denied. (System.Data)” trying to connect to the Azure SQL Database database using Azure Active Directory Integrated Authentication.
 
After some… Continue reading Lesson Learned #192: MSIS7068-Access denied error message connecting to Azure SQL Database using AAD

Authenticating Azure API connections in Single-Tenant LogicApp workflows to debug in local VS Code

 
Single-Tenant Logic App offering provides the capability to test the Workflows in local dev environment (VS Code). In Single-Tenant Logic App workflow , we have two categories of connectors i.e. Built-In and Azure connectors. Built-In connectors… Continue reading Authenticating Azure API connections in Single-Tenant LogicApp workflows to debug in local VS Code

Best practices for integrating serverless SQL pool with Cosmos DB Analytical store via Synapse Link

The serverless SQL pools enable you to implement near-real-time analytics solutions on top of your Cosmos DB data. Serverless SQL pools with the Synapse Link provide a cost-effective analytics solution for analyzing NoSQL data stored in Cosmos DB, whic… Continue reading Best practices for integrating serverless SQL pool with Cosmos DB Analytical store via Synapse Link

Set up an Azure-SSIS Integration Runtime (IR) in Azure Synapse Analytics using PowerShell

The Azure-SSIS Integration Runtime is a fully managed cluster of Azure VMs dedicated to run your SSIS packages. You can bring your own Azure SQL Database or SQL Managed Instance for the catalog of SSIS projects/packages (SSISDB).
To lift and shift exis… Continue reading Set up an Azure-SSIS Integration Runtime (IR) in Azure Synapse Analytics using PowerShell