Optimizing CPU cores and threads for Oracle on AWS

A Smarter Way to Scale: Custom CPU Options on AWS

About a couple of weeks ago, AWS introduced a new option ...

Text index usage within MongoDB

Igor Donchovski Published : Aug 24, 2023 Last Updated : Jul 30, 2018 3 min read

How to schedule weekdays only on Airflow

Consider the following situation: You have a data ingestion pipeline where the data comes in real-time on weekdays ...

Neo4j cluster using Vagrant, Ansible and Virtualbox

Recently, I was faced with the need to create and configure a Neo4j cluster. In order to be able to easily ...

Setting up MySQL encrypted replication on MySQL 5.7 with GTID

In this blog post, I'll walk you through setting up encrypted replication on MySQL 5.7 with GTID enabled. I will walk ...

An Oracle "oraenv" script solution for Windows with PowerShell

The idea

How to restore encrypted backups

Background

SQL Server started having encrypted backups since SQL Server 2014. You can see the technical ...

Log buffer #551: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle and MySQL.

Database migration: how to handle large tables

In the previous blog, we presented a simple

EBS 12.2 issues seen in the wild

Recently, I was involved in an EBS upgrade project, and also in operational support of an EBS production environment. ...

Log buffer #549: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle, SQL Server and MySQL.

Log buffer #548: a carnival of the vanities for DBAs

This log buffer edition covers blog posts from Cloud, Oracle and MySQL.

Getting started with Orchestrator

Orchestrator is a MySQL high availability and replication management tool. In this blog post, we will cover the ...

How to efficiently back up and restore crontab

When a database environment is being patched, entries from crontab are commented and then removed when patching is ...

Installing Oracle 18c using command line

Introduction

Just three days ago Oracle released Oracle 18c for general installation on-premises. We've had ...

Cassandra CQL cheatsheet

Context:

Every now and then I find myself looking for a couple of commands I do often. In some other ...

Data modeling for cloud DW

Intro

In this blog post, I would like to share ...

HAProxy MySQL lag awareness via systemd

Background

In one of the projects I have been working on, one requirement was the ability to stop traffic ...

Analyzing BigQuery via Excel and Google Sheets

Both MS Excel and Google Sheets offer ways to connect directly to BQ data, to run ...

Azure Data Lake basics for the SQL Server DBA / developer and... for everyone!

The basics

How to manage multiple MySQL binary installations with SYSTEMD

This blog will go into how to manage multiple MySQL binary installations with SYSTEMD using the systemctl command. With ...

Choosing best index for your MongoDB query

Introduction

Indexing plays a quintessential role in database query performance and MongoDB is no ...

Getting started with Oracle Database Backup Service in 2018

A few years ago I wrote an article on getting started with the Oracle Database Backup Service which can be found

HugePages for Oracle database in Oracle Cloud

I recently published a

Airflow Scheduler: the very basics

Apache Airflow is a great tool for scheduling jobs. It has a nice UI out of the box. It allows you to create a directed ...

Fixing could not start service broker for database

Introduction

Blogging is something I love because it gives me a chance to share the ideas I have and the ...

Installing SQL Server 2008 R2 on Windows 2012 cluster

Despite being an older version, some applications may require you to install a SQL Server 2008 R2 clustered instance on ...

GCP features wish list for Google Next 2018

As I've just posted about Pythian at Google Next, I thought it would be cool to share the new GCP features I'd love ...