At the end of last year, I attended a virtual conference organised by Snowflake for the Asia-Pacific region. The beauty of online event is that you can watch sessions on demand, which is handy as many interesting sessions were scheduled to be streamed at the same...
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...
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...
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...
Recently The Cloud at OptimalBI has taken a more bluish tinge. We have always liked a little Microsoft here at OptimalBI Ltd with our C#s and our SQL Servers, and as such our ventures over to the land of the long blue cloud were inevitable. Azure is one of the fastest...