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→