Software Engineering

Something that comes up quite frequently when people start using Spark is "How can I filter my DataFrame using the contents of another DataFrame?". People with SQL experience will immediately look to trying to replicate the following. SELECT * FROM table_a a WHERE EXISTS (SELECT * FROM t

Documentation is not something people often spend time reading, or if they do then its to quickly find the one thing their after and then get out as quickly as possible, very similar to how I do my Christmas shopping. Sometimes it's worth spending time reading the documentation though as there can b

I recently posted a tweet in which I briefly mentioned that I'd been writing a simple Azure Function using Kotlin . I thought I'd put together something a bit more in-depth, and which did something a bit more than say hello back based on a name in the query string (although I do cover this below,

I've posted about Azure Data Studio before (then called SQL Ops Studio) but wanted to just bring it up again, specifically where it's helped me in a specific use case. We have a scenario where a model created by one of our Data Scientists is predicting values for the next few days, what I wanted t

A while ago I wrote a post about extracting data from SQL and into Parquet . This was aimed mainly at on-premise systems where Data Gateway or others are not an option but you still want to get your data into a format which can be used by tools such as Azure Databricks . Since that post Parquet

One of the things I often find myself doing is collecting data from external sources to get at feeds of data such as weather, pricing, scheduling etc... Often these sources have been around for a while and the world of APIs has moved on, meaning we often find data in massively nested structures, XML

Frequently we get requirements for UTC times in Azure SQL databases to be converted into various world time zones. Whilst scripting within the table builds and adding columns, or relying on sever settings, can produce this outcome there is a more flexible approach using the AT TIME ZONE (T-SQL) s

There's still one thing we encounter all to frequently when working with, manipulating or simply extracting data. We can book tickets over our mobile phones, check the news, integrate AI into our websites and determine if one message should be reviewed before another based on sentiment analysis. But

You might have read a post from me once-or-twice where I've advocated using Python for quickly prototyping solutions, exploring data etc... But regardless of whether you're using it for building a quick prototype or create a larger application it is, as with all languages, best practice to write s

We don't all have a bottomless pit of money and I think most of us have learnt by now that it certainly doesn't grow on trees, so in our home lives we keep an eye on how much we're spending otherwise we get ourselves into trouble. The same is true when building services in the cloud. Even large, mul

Operationalising Data Science is something of a difficult question for us here at Elastacloud, given the wealth of options available (AzureML, Spark, python web service etc). Recently as part of Renewables we’ve been updating our model to the latest and greatest and wanted to move away from using

One of the requirements we most often come across when working on solutions involving Azure Analysis Services is for rolling date time values so that the end user can filter their data based on calendar-based sequences (e.g. rolling day, week, month or year sequences). I have found that one of th

Lately I've needed to extract some data from a SQL database (and others) and move it into Azure to be worked on using other tools. We're big users of Parquet which is available across a range of tools such as Azure SQL Data Warehouse , Azure Data Lake Analytics and of course, Spark . The first c

I saw this the other day and had to grab a quick picture of it, but I will add that I left both the lock and the locker contents alone after that. It did get me thinking about how we view security in the software industry which, given recent events, is more visible now than it has been in the past.

When working with Database Projects you will sometimes want to use a post-deploy script to perform any number of operations on the database every time the database project is deployed to a target database. In doing so you may encounter an error such as the following: ‘Error SQL71006: Only one sta

Recently I needed to deploy an Azure Data Lake Store - Gen 2 instance and thought I'd take the opportunity to use some custom ARM template functions . These aren't something you often see in the example templates but can be really useful if there's a complex expression which you find yourself wri

Durable Functions is an Azure Functions SDK extension which enables the Azure Function server-less environment to run "stateful" applications. The following example below briefly demonstrates the Fan In/Out pattern that the Durable Functions SDK enables with ease. In this simple example, a me

We started Elastacloud eight years ago by focussing on High Performance Computing on Microsoft Azure. HPC is normally in the purview of Researchers, Engineers and Risk Calculators in finance but it is good for so much more. Here over the next few posts I'll break down the problem domain and why I di

Dates, you either hate them or you're not paying close enough attention. Recently I've needed to break a day down into buckets of time for a project, for most days of the year this is fine and the 24 hours of the day (and yes, I know, but I can ignore that part for now) nicely breaks down into equal

So you've been given access to an API which is an HTTP triggered Azure Function which is secured using Azure Active Directory, it needs to be called programmatically so you've been given a few things to do this including An Azure tenant id An application id and secret The applications id URI A funct

I was busy scanning through various news feeds and came across a link to a post talking about how to use Azure Storage in a DotNetCore application. Curious as always at seeing how others do things I followed the link and was immediately hit with one of my pet peeves, there at the bottom of the scr

Microsoft have now released a v2 of Data Factory. Though this is still in preview, it has the handy ‘Author and Deploy’ tool; this includes the copy activity wizard to assist creating a copy data pipeline. Most of this is the same as v1, however there are changes that have been introduced in this