How to Set Up an 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.
How to Set Up an 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: The Complete Step-by-Step Guide
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: The Complete Step-by-Step Guide Read More »