This article describes how to create and configure a self-hosted Azure DevOps agent in an on-premise Windows machine. Continue Reading
Automate Azure SQL Database index and statistics maintenance tasks using the Azure Elastic Job agent. Continue Reading
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. Continue Reading
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. Continue Reading
A step by step guide for preparing for Azure AZ-204 exam Continue Reading
SSIS Catalog migration wizard migrates SSISDB catalog from one SQL server to another or to Azure SSIS runtime in just a few clicks.
It is an add-in for SSMS 2018, Visual Studio 2017 and Visual Studio 2019. It is published on Visual Studio Marketplace. Continue Reading