SSIS Catalog Migration Wizard (SCMW) grants you more control to migrate SSISDB catalog objects from one server to another. Supported migrations SCMW file type SCMW file type is an export format of the SSIS Catalog Migration Wizard. It can act… Continue Reading
Azure Data Factory uses Integration Runtimes as a compute infrastructure to execute data movement and data transformation activities. This article describes how to set up Azure Data Factory Shared Integration Runtime. Continue Reading
To secure connection details in data factory, we can store credentials in the Azure key vault and access them in Azure data factory. This article describes how to access Azure key vault secrets from Azure data factory linked services. Continue Reading
This article describes how to get local time zone date in Azure SQL database using an user defined scaler function and AT TiME ZONE. Continue Reading
Microsoft has enabled support for accessing Microsoft Graph API from Azure data factory. In this article, we will see how to call Graph API from Azure data factory using the managed identity. Continue Reading
This article describes how to share Power BI reports with external users using Azure B2B. Continue Reading
In this article, we will see 3 SSIS design patterns that we can use to set up SSIS configurations and deployments. Continue Reading
Migrate Azure data factory from one resource group to another using these 3 simple steps. Continue Reading
Are you planning to migrate your SSIS Catalog to a newer version of SQL Server? You might like to know if your SSIS Catalog has any issues. Some of the most common issues in SSIS catalog could be: SSIS projects… Continue Reading
This article describes how to create and configure a self-hosted Azure DevOps agent in an on-premise Windows machine. Continue Reading