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...
Our Blogs
WE LOVE TO SHARE
Learning Azure with Pluralsight
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...
ETL is Easy Again in Azure Data Factory
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...
Snowflake and Qlik: End-to-End BI Solution
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...
Change Data Capture (CDC)
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've started a MongoDB Meetup group – sign up!
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: Useful for CloudBI/Cloud Development?
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...
Moving a Database into Azure: Are We in a Cloud yet?
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...
Upgrading MongoDB 3.4 to 3.6 on Ubuntu 16.04: Easy as Microwave Pie
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...
Setting up PrestoDB on Linux
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...