Part 2: Data Vault for beginners

This article is one of the four articles written to easily understand the Data Vault architecture. Part two covers the Data Vault Staging environment, Hash Key computations and preparation of the staging data for the Data Vault loading. Overview of the Data Vault Staging The main purpose of the staging environment is to reduce the … Continue reading Part 2: Data Vault for beginners →

Part 1: Data Vault for beginners

This article is one of the four articles written to easily understand the Data Vault architecture. Part one covers the Data Vault overview, Data Vault architecture and the OLTP source that has been used for the Data Vault design. Please note that the OLTP, Staging, Vault and InfoMart databases developed for this series are all … Continue reading Part 1: Data Vault for beginners →

How to copy an Azure SQL database from one subscription to another subscription using PowerShell

Below instructions are useful when you would like to copy the database from one Azure subscription to another subscription using PowerShell. Install PowerShell on your computer. For requirements and installation, refer to the url: https://docs.microsoft.com/en-us/powershell/azure/install-az-ps?view=azps-2.2.0After the installation, open the “Windows PowerShell ISE” as an administrator.Install the Azure PowerShell module using the command below (press ‘Y’ … Continue reading How to copy an Azure SQL database from one subscription to another subscription using PowerShell →