Table is required for Copy Activity

I've seen a lot of people manually create tables in Azure SQL when doing a data migration from a source system to SQL DB as the Sink. For those that…

Integration testing with Data Factory, Data Lake, Dynamics 365 Finance & Operation

Just for fun, I decided to play around with Azure Data Factory (ADF), Azure Data Lake Storage (ADLS) and Microsoft Dynamics 365 Finance & Operation VM. I wanted to see…

Designing a Modern Data Warehouse – Available Options

I recently spent some time with Microsoft to look at the various options for building our big data pipelines. Here are the final options that exist for anyone considering doing…

Transfer an Azure Subscription between tenants

Here's a quick tip for those that have subscriptions between tenants, that want to manage or transfer a Subscription between Azure tenants.

Create a Microsoft Cloud account and link with Azure Active Directory

Microsoft recommends that you create at least two Microsoft cloud accounts (onmicrosoft.com) and make them Global Administrators (GA). One should have Conditional Access and the other MFA enabled.

Azure Resource Tags – Enforce tag creation on Resource Groups and Resources

One of the key recommendations when adopting Azure as a cloud platform is good naming standards. Microsoft has a best practice recommendations but keeping it simple is always the best…

Azure SQL Server security first steps

This post is a summary of the Microsoft Azure Tutorial: Secure a single or pooled database.

Access review of groups or applications

This is a very simple feature that provides great rewards. Managing large groups of Users in AAD can be cumbersome, especially in organisations where staff are always being hired or…

Azure Solutions Architect Expert

There are over 200+ areas that an Azure Solutions architect should confidently know. Below is an extract of both the AZ-300 (Microsoft Azure Architect Technologies) and AZ-301 (Microsoft Azure Architect…

Azure Lab Services

Microsoft just announced the release of Azure Lab Services. It allows you to quickly deploy Virtual Machine (VM) templates based on very simple configurations. This is great for anyone that…