Cloud solutions have little to do with the solutions we have on-premises. Cloud solutions are built with ambitious and monstrously huge goals in mind, so, often it feels like no previous technology has been reused. In addition to some understandable concepts, like...
Almost two years ago I was a part of the BI team in an organization that decided to move to the Cloud. As a first step they followed the lift and shift approach, so they moved their Data Warehouse and all the existing processes into the Azure environment almost...
Recently I watched a webinar organised by Snowflake, it was called "Data Warehouse Automation, Ingestion and Industry Leading Analytics with Snowflake and Qlik". In the past I could never find time for webinars, and it's amazing how life can give you opportunities to...
On a daily basis I have the benefit of working with organisations who are somewhere on a journey with data. Working with big or small, flush or practically bust, petabytes or megabytes, organisations see some innovative solutions deployed. One thing I often see...
We use MongoDB as part of our daily life at OptimalBI, and we love it. We did notice that there's not really a Wellington user community, so we figured we'd better fix that! We're pretty happy to announce that there's now a MongoDB Meetup in Wellington! ...
Amazon Workspaces have been around for a while now, so I thought I'd give them a go and see what's what. What is this Amazon Workspaces thing then? Amazon Workspaces is Amazon/AWS virtual desktop as a service offering. It allows IT Administrators to provision desktops...
The idea of moving into Cloud service takes over minds in organisations I work with. On my previous project we had our databases in Azure, and my current customer is starting the migration project next month. For most of people moving into cloud means everything stays...
MongoDB 3.6 has some awesome features, change streams being my personal favourite (see all the changes here), but what if we have an old MongoDB cluster running on 3.4 and want to use these cool features? Here is how! Note: This guide assumes you installed MongoDB...
If you've chatted with me in depth about BI/DW it's highly likely I've mentioned Presto - an open source project I've been following for the last few years. Presto is a "SQL on anything" distributed SQL query engine which was developed by Facebook and publicly...
MongoDB is a very popular database, in fact, we love blogging about it. But what is MongoDB? And what are the best things to do with it, and what shouldn't I do with it? I get asked this a lot so here are the answers to these questions. Don't worry if you're not a...