In our previous discussion we explored the application of data governance programs to legacy technology platforms. We explored methods to ensure high levels of integrity with data managed on these legacy platforms and what organizational investments allow us to reduce risk and…

Patroni Patroni is a High Availability solution for PostgreSQL using asynchronous streaming replication, Etcd, and HAProxy. For more details, you can read the Patroni documentation which is really good and covers many details. In this post, I will explain: Patroni architecture Ansible for patroni cluster…

What is Apache Airflow? Airflow is a platform to programmatically author (designing pipelines, creating workflows), schedule, and monitor workflows. These functions are achieved with Directed Acyclic Graphs (DAG) of the tasks. It is open-source and still in the incubator stage….

Google wants to ensure that its customers are successful in the cloud. To do that, partners play a vital role, particularly in areas that require skilled expertise such as data analytics, artificial intelligence, Kubernetes and other emerging tech. That’s why…

Oracle has a documented process for using Oracle logical standby transient Database (TLS) to minimize downtime during database upgrades. I would like to share my experience in the real world using this process to get an Oracle database migrated. I…

Running a business in a technological era is exciting, however tough to keep up with. It seems like everyone and their neighbor has the latest and greatest when it comes to maintaining a technological edge. Landscape shifting services and products…

Summary In this blog I will explain pg_rewind use case to solve split brain after a database failover happens. Split Brain Syndrome Split Brain is often used to describe the scenario when two or more nodes in a cluster, lose…

In our previous post we discussed the governance requirements for creating, managing and deploying analytical models. Analytical models do not stand on their own in today’s complex data landscapes. They have unique needs that must be captured in policy, automated…

Introduction As data’s importance in business grows, so do the pressures it exerts on modern organizations. In the wake of these demands—or Drivers, as outlined in SAPinsider’s DART (Drivers, Action, Requirements, Technologies) model—enterprises strive to turn data into value. As…

As a managed service company, we see our customers and partners shifting their workloads to the cloud. There are various reasons for this decision, but the most important ones are cost and agility. Once on a cloud, the infrastructure team…