Azure CosmosDB – the new dog in the Cloud. Surely our old friend SQL is good enough?

For years, as developers we have chosen by default some form of SQL or relational database management system  – RDBMS to store application data – probably because that is all there was at the time. But now we are entering the age of the cloud and alternatives are beginning to appear. so how does RDBMS fair? Continue reading “Azure CosmosDB – the new dog in the Cloud. Surely our old friend SQL is good enough?”

Understanding and becoming GDPR compliant – part 2

The General Data Protection Regulations (GDPR) will soon be upon us. See part 1. So how can we build a public facing infrastructure to move to GDPR compliance? What kind of GDPR focused applications can we expect to appear on the market and what are they likely to look like? Continue reading “Understanding and becoming GDPR compliant – part 2”

Understanding and becoming GDPR compliant – part 1

The General Data Protection Regulations (GDPR) will soon be upon us from 25th May 2018. They will further enforce legal obligations on organisations and individuals who store personally identifiable data (PII)  (Article4-1) when dealing with or within the EU, with hefty fines for non compliance and granting more rights to individuals to whom the PII belongs. Continue reading “Understanding and becoming GDPR compliant – part 1”

What’s my property worth? An introduction to Azure Machine Learning

Your aim is to build and publish a cloud based property price application. The application will predict a properties current worth from past sales data. You have heard that Azure Machine Learning (AML) can help and so you want to gain understand of the AML terminology as you go along.  Continue reading “What’s my property worth? An introduction to Azure Machine Learning”

How to Monetise your Legacy data using Azure API Management with Logic Apps or VPN

Many established organisations hold data on internal legacy systems that have huge potential commercial value to other third party organisations. It maybe impractical or have restrictions preventing this data being moved to the cloud.   Continue reading “How to Monetise your Legacy data using Azure API Management with Logic Apps or VPN”

How Many Ways to Secure your Azure API Management Infrastructure?

You are a financial technology company (fintech) and you are considering provisioning Azure API Management (APIM) as part of your EU PSD2 and UK Open Banking strategy for public facing Web APIs. Security is at the top of your agenda and you need to know what mechanisms are available to secure APIM and your Web APIs? Continue reading “How Many Ways to Secure your Azure API Management Infrastructure?”

Assembly Line Patterns using Azure Logic Apps & Service Bus Topics

Linear Assembly Line – Azure Logic App

Let us consider a typical linear assembly line. This is where an object is placed at the beginning of the assembly line and travels on its journey in a straight  line or linear fashion. Continue reading “Assembly Line Patterns using Azure Logic Apps & Service Bus Topics”

Using Swagger/OpenAPI to define and build your Azure API App

Microsoft Azure provides the API App as part of its App Service offering. This supports companies or individuals exposing data and business processes over the web as an ‘API’, or application programming interface. Up until recently, there was no common standard in defining an API and there was free reign….

Continue reading “Using Swagger/OpenAPI to define and build your Azure API App”

Writing an Azure Function to programmatically update Azure Data Factory

Let’s imagine that we create an Azure Data Factory (ADF) with a pipeline containing a Copy Activity that populates SQL Azure with data from an on-premise SQL Server database. If we set the schedule with a short interval, say to run every 15 minutes over a 3 month period, then we will discover that it will generate a large number of executions or slices (around 9000). Continue reading “Writing an Azure Function to programmatically update Azure Data Factory”

Copying data from On-Premise ODBC to Sql Azure using Azure Data Factory Copy Activity

Azure Data Factory (ADF) is a great cloud product for copying virtually any kind of data: on-premise, in the cloud, or between on-premise and the cloud. It has user designed pipelines with activities to transfer data and is configured using JSON templates. However, writing these templates is not easy. Continue reading “Copying data from On-Premise ODBC to Sql Azure using Azure Data Factory Copy Activity”