Get local date in Azure SQL database
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 »
Share Power BI Report with External Users
This article describes how to share Power BI reports with external users using Azure B2B.
Share Power BI Report with External Users Read More »
SSIS Environment Design Patterns
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 »
Export and Import Azure Data Factory
Migrate Azure data factory from one resource group to another using these 3 simple steps.
Export and Import Azure Data Factory Read More »
Azure DevOps Self Hosted Agent
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 »
Automating Azure SQL Database Maintenance Tasks
Automate Azure SQL Database index and statistics maintenance tasks using the Azure Elastic Job agent.
Automating Azure SQL Database Maintenance Tasks Read More »
Azure Data Factory Deployment using Azure DevOps
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 »
Create BACPAC File From SQL Database
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 »