Confluent Cloud provides ksqlDB, a streaming SQL engine for Kafka. It is an easy-to-use yet powerful interactive SQL interface for stream processing on Kafka, In this article, we will see how to automate Confluent ksqlDB deployments using ksql-migrations.
Automate Confluent ksqlDB deployments with ksql-migrations Read More »
This article describes how to get local time zone date in Azure SQL database using an user defined scaler function and AT TiME ZONE.
Get local date in Azure SQL database Read More »
This article describes how to share Power BI reports with external users using Azure B2B.
Share Power BI Report with External Users Read More »
In this article, we will see 3 SSIS design patterns that we can use to set up SSIS configurations and deployments.
SSIS Environment Design Patterns Read More »
Migrate Azure data factory from one resource group to another using these 3 simple steps.
Export and Import Azure Data Factory Read More »
This article describes how to create and configure a self-hosted Azure DevOps agent in an on-premise Windows machine.
Azure DevOps Self Hosted Agent Read More »
Automate Azure SQL Database index and statistics maintenance tasks using the Azure Elastic Job agent.
Automating Azure SQL Database Maintenance Tasks Read More »
Recently, Microsoft has announced that they now support automated Azure Data Factory publish using ADFUtilities NPM (@microsoft/azure-data-factory-utilities) library. This library provides basic functionality to validate and generate an ARM template given a set of Data Factory resources.
Azure Data Factory Deployment using Azure DevOps Read More »
BACPAC is a zip file containing SQL Server database metadata and data from the database. This is kind of a database backup that is mainly used to restore the on-premise database to Azure SQL.
This article describes how to export BACPAC of SQL server database for Azure SQL migration.
Create BACPAC File From SQL Database Read More »
