Dipping Your Toes Into Building an Analytics Platform on Google Cloud Platform

“We have many disparate data sources and we’re having a hard time getting a global view of all our data across our organization.” “Our data is currently all in <enter data warehouse name here> and we want to migrate it…

Read More >

Adding Your RDS Fleet to PMM2 Using the API

PMM (Percona Monitoring and Management) is a great community tool for monitoring your OSDB (MySQL, PostgreSQL, MongoDB) fleet. It’s feature rich, and it’s built and distributed as open-source based on several de-facto industry standard tools such as Grafana and Prometheus….

Read More >

VPN Options with Azure, Part 1: Azure to Site

As business entities move some of their services to Microsoft Azure Cloud (Azure), we see hybrid networks emerge that can span multiple physical sites and multiple cloud environments. Connecting those network segments securely can present some challenges. I’ve encountered two types…

Read More >

Migrate Postgres Database from EC2 instance to RDS using AWS DMS (Data Migration Services)

In this post, we will explore one approach to Migrate PostgreSQL DB on EC2 instance to RDS instance using AWS Data Migration services. Amazon Relational Database Service (Amazon RDS) is quite popular because of its easy setup, operation, and auto-scalability….

Read More >

Global Analytics with Azure Cosmos Db and Synapse Analytics – SQL On The Edge Episode 21

A few months ago, Microsoft revealed that they were looking into adding a capability of querying Cosmos Db data through Spark and this immediately got me thinking into the new scenarios this would enable. The most ambitious is the capability…

Read More >

Navigating the Digital Transformation: Our Top 7 Cloud and Data Resources

In the midst of the digital transformation, more businesses than ever before are leveraging their data and cloud computing platforms to shift how they operate in and keep up with the rapidly changing environment. In order to get the most…

Read More >

AWS RDS: 5 Must-Know Actions for Oracle DBAs

Managing Oracle on AWS has some twists. Here are five daily DBA activities that have changed on AWS: Kill Sessions: begin rdsadmin.rdsadmin_util.kill( sid => &sid, serial => &serial, method => ‘IMMEDIATE’); end; /   Flush shared_pool or buffer_cache: exec rdsadmin.rdsadmin_util.flush_shared_pool;…

Read More >

Installing OCI Command Line Utilities in Linux and Windows

There are multiple documented methods for installing the Oracle Cloud Infrastructure command line utilities (oci). Some methods work better than others, but sometimes none of them meet your needs. This is a story of getting the installation done to meet our needs.

Read More >

How to Connect from Cloud Functions to the Private IP Address of Cloud SQL in Google Cloud

Cloud functions allow you to run single-purpose functions without having to manage instances in Google Cloud. Cloud SQL is Google Cloud’s managed SQL service. For better security, it’s best practice to disable public IP in Cloud SQL. In terraform, the…

Read More >

How Pythian and Google helped reduce pesticide use in high-value crops

Semios is a Vancouver-based data analytics company for growers of high-value crops such as almonds and apples. It uses a combination of machine learning, in-crop wireless networks and half a million IoT sensors across 80,000 acres to offer real-time monitoring…

Read More >
Page 1 of 1812345...10...Last Page »