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 >

Datascape Podcast Episode 41 – Choosing a Public Cloud for Oracle Database

You can run Oracle anywhere. It’s very flexible, which means anywhere you can get a VM, you can run it, including a virtual box on your laptop. There’s even have a free edition (XE) if you don’t have large data…

Read More >

101 Series: Oracle in Google Cloud – Part 2 : How I Built the GC VM with Ansible

Setup the gcloud Account, JSON File, and the SSH Keys Explaining the Ansible GC Compute Modules

Read More >

Join, Group By, and Aggregate in Cloud Data Fusion

Good news! Cloud Data Fusion is now GA. Announced at Google Next ‘19 UK on November 21, 2019, Cloud Data Fusion is a fully managed, cloud-native, enterprise data integration service for quickly building and managing data pipelines. Cloud Data Fusion…

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