Exam MB-400 Revision Notes: Implementing Data Synchronisation with the Data Export Service

Today, we are looking at the final topic for the MB-400 exam – the Data Export Service - a convenient tool to use when performing simplistic integrations involving Dynamics 365 Online or the Common Data Service. What’s more, it’s dead easy to set up too...

Working with Common Data Service Owner & Customer Fields in Azure Data Factory V2

Azure Data Factory (ADF) remains a massive area for me, and within the projects I'm involved in. Previously, those looking to use ADF to map into Owner or Customer fields in the Common Data Service may have hit a few issues. Thankfully, this is now all in the past.

Dealing with “SQL Bulk Copy failed due to received an invalid column length from the bcp client” Errors in Azure Data Factory

When you are amid a pesky IT issue, it can be difficult determining whether the problem is down to a bug/system fault or human error. Like this recent example involving Azure Data Factory illustrates, it is generally best to assume the latter, to avoid any prolonged difficulty.

Handling British Summer Time/Daylight Savings Time in Azure SQL

Is it just me or is British Summer Time (BST) AKA Daylight Saving Time (DST) an utterly pointless endeavour these days? Admittedly, on its introduction in 1916, it fulfilled a sensible objective - to provide more daylight hours during the summer. For agricultural, construction or other services that are reliant on sufficient light to carry [...]

‘An unexpected error occured while processing the request’ Error when Downscaling an Azure SQL Database

When considering whether or not to shift your existing SQL workloads to a single database offering on Azure SQL, one of the major pros is the breadth of capabilities the service can offer when compared with other vendors or in comparison to SQL Server on an Azure Virtual Machine. A list of these may include: [...]