The similarities between designing an electrical grid and an auto-scaling cloud architecture for optimal availability.

Disclaimer

I am not an energy expert. While I have a lot of experience in the Upstream Oil and Gas industry, I’m not nearly as familiar with the nuances of the other portions of the energy value chain.

Also, I still have a lot to learn about the cloud, but as an AWS Certified Solutions Architect, I believe am qualified to discuss this topic as it is very high-level.

Background

As many of you are aware, a massive arctic blast/winter storm swept through much of the United States this past week and caught many in the south, especially my home state of…


Simple, robust deployment of “Dockerized” applications with Azure Container Registry and Instances through the Docker CLI

TL;DR

The Docker CLI, in conjunction with Azure Container Registry and Azure Container Instances, makes containerized app deployment a breeze.

Background

I had to write a custom alert/webhook integration between Grafana and Slack for a client (maybe it’s own article?!). After writing the Python Flask app, I had do decide how we wanted to deploy it. I’ve used AWS quite a bit, but my client already had an Azure account. While I was not very familiar with Azure and had limited Docker experience, my experience deploying the application was refreshingly pleasant and straightforward. …


Import and Bulk Insert Amazon S3 files directly to your Amazon RDS for SQL Server database.

TL;DR

With the support of S3 integration, you can now download .csv, .xml, .txt. and other file types from Amazon S3 directly to your Amazon RDS for SQL Server database and import that data with Bulk Insert.

Background

Recently, an oil and gas client asked if we could consume data from a well lifecycle reporting system, so we could integrate it with other systems for data analytics. Seeing as the reporting system is a cloud-based, Software as a Service(SaaS), I assumed(you know…that whole chestnut) they had a RESTful API we could tie into and told the client that shouldn’t be a problem.


How to use R and TERR to access geospatial features via WFS in Spotfire

Disclaimer: I am not a GIS professional…but I did stay at a Holiday Inn Express last night!

TIBCO Spotfire is one of my favorite BI/analytics tools and is particularly great at geospatial analytics. That said, one “hole” it does have in that arena is the lack of support for Web Feature Services(WFS) as a data source. Luckily, Spotfire provides the TERR engine to run R data functions in the background. I’ll show you how to utilize TERR to overcome TIBCO’s lack of direct WFS support.

What is supported?

The core methods for adding geospatial data to Spotfre are importing shapefiles(.shp) or querying spatial…

Bobby Neelon

Data Analytics Professional, Cloud Enthusiast, Sports Nerd

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store