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 >

How Cloud Computing Has Transformed Over the Last Decade

As we look back on the past ten years, cloud computing may be considered one of the largest transformations in technology, heavily adopted by users of all kinds. Regardless of the industry, it’s no secret that the cloud has transformed…

Read More >

Google Cloud (GC) Cloud SQL Disaster Recovery

This blog post describes how to enable roll-your-own Disaster Recovery in GCP Cloud SQL. This process is automated and will save money. However, recovery is manual. Introduction One of the benefits of using the cloud is the ability to track…

Read More >

Improve your security posture by upgrading to Azure SQL Database

Every now and then I have a conversation with a client who is still reluctant to consider a cloud migration due to what they perceive as a decrease in their security posture. Once we start analyzing this position in detail…

Read More >

How to Run DBSAT 2.2.0 on Oracle Cloud PDB using Wallet

The Oracle Database Security Assessment Tool (DBSAT) is a command-line tool focused on identifying how securely the database is configured and where sensitive data resides with the goal of promoting successful approaches to mitigating potential security risks. DBSAT requires no…

Read More >

AWS’s Top 5 Commands: ALTER SYSTEM and Managing SYS Objects in RDS

We often manage services over EC2, this is not news. But when migrating to Amazon RDS, it’s usual for new users to have issues with performing some administrative actions on the database, especially when it’s done via internal Oracle procedures…

Read More >

Troubleshooting Oracle Cloud Infrastructure Automatic Backups

I could start this blog the same way I started this one because everything is supposed to be easy and at a 1 click distance in any cloud, so it should be the same for the database backups in Oracle…

Read More >

How to get the most out of your EBS performance

A commonly encountered scenario is when EBS volumes are not performing at the expected theoretical performance. Let’s look at some of the potential reasons for that and how we can “fix” it. (When I say EBS volume, I am talking…

Read More >

Examining Teradata To Google BigQuery Migration

Cloud migration is hot nowadays. Enterprises are considering options to migrate on-premises data and applications to cloud (AWS/GCP/Azure) to get the benefits of quick deployments, pay-per-use models and flexibility. Recently, I got a chance to work on data migration from…

Read More >

How to Autoscale ProxySQL in the cloud

ProxySQL is a great tool. It’s one of the most recommended technologies in our Open Source Database practice. Many of our clients are running it or are migrating towards it, but we’ve seen that it is pretty CPU-intensive. We’ve also…

Read More >
Page 3 of 1912345...10...Last Page »