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 >

Running new Oracle DBSAT version 2.1.0 against Autonomous Database

Recently Oracle released the newest version of the “Database Security Assessment Tool” (DBSAT 2.1.0). This version is certified to run against Oracle Cloud DBCS (PaaS) and Autonomous Databases. Also, the Discoverer option can now find sensitive and personal data in…

Read More >

Save time with this quick OCI CLI installation

This is more of a personal reminder than anything else, but hopefully it helps save some time for others trying to install the OCI CLI on their local Linux machines. The idea is to have a very basic set of…

Read More >

How to build a cost-effective serverless blogging platform on GCP – Part 2

Welcome back to the 2nd part! Last time, we set up the tools that allowed managing the blog as a set of configuration and Markdown-formatted files stored in a source code repository. Now it’s time to deploy the blog on…

Read More >

How to build a cost-effective serverless blogging platform on GCP – Part 1

I remember when I started blogging in 2008. It was a nice learning experience, and it was rewarding, too – both the challenge of formulating my thoughts clearly and the feedback I received, and still am receiving, on some of…

Read More >

Accessing Oracle Cloud Infrastructure (OCI) using Google G Suite SSO

Background One of the nice things about so many web apps these days is how easily they integrate with Google authentication and Single Sign-on (SSO). This is thanks to web-based authentication and authorization technologies such as SAML and OAuth. So…

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