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 >

Scaling ProxySQL rapidly in Kubernetes

It’s not uncommon these days for us to use a high availability stack for MySQL consisting of Orchestrator, Consul, and ProxySQL. You can read more details about this stack by reading Matthias Crauwels’ blog post How To Autoscale ProxySQL In…

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 Implement Airflow Best Practices from a Data Scientist’s perspective – Part 1

This blog post is a compilation of suggestions for best practices drawn from my personal experience as a data scientist building Airflow DAGs and installing and maintaining Airflow. Let’s begin by explaining what Airflow is and what it is not….

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 >

How to fix SQL backup to URL error: The remote server returned an error: (400) bad request

Problem: You are trying to take a native SQL Backup to URL and you receive the error below: Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file “https://MyStorageAccount.file.core.windows.net/MyContainer/Adventureworks_full_20190420.bak:” Backup to URL received an exception…

Read More >

How to run DBSAT against Oracle RDS database

The scope of this article is to show how to run DBSAT (Oracle Database Security Assessment Tool) against an Amazon RDS Oracle instance. This is based on a real-life execution. The DBSAT version used was 2.0.2 over an RDS database…

Read More >

How to fix SQL backup to URL failure – operating system error 50

Problem: You run an SQL backup to URL and get the following error: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device ‘https://<mystorageaccountname>.blob.core.windows.net/<mycontainername>/AdventureWorks_full_20190420.bak’. Operating system error 50(The request is not supported.). Msg 3013, Level 16, State 1,…

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