Powershell error: sqlps.ps1 cannot be loaded because running scripts is disabled on this system

Introduction An interesting issue came across my desk this week. One of our clients has a number of PowerShell tasks ...

MySQL high availability with HAProxy, Consul and Orchestrator

Introduction In this post we will explore one approach to MySQL high availability with HAProxy, Consul and ...

MySQL streaming Xtrabackup to slave recovery

Restoring a MySQL slave by manually taking a backup and then copying the file over the network can be an incredibly ...

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 experiment ...

Why is my Forms 12c Application so slow?

After a recent upgrade Users cannot work with the forms application anymore; it has been a few weeks since an upgrade ...

RDP Issue - CredSSP encryption Oracle remediation

Introduction We have recently had some issues accessing a few client servers and found it is related to a Windows ...

An Oracle "oraenv" script solution for Windows with PowerShell

The idea Due to the nature of my consulting work, I mostly work in Linux environments and use bash for scripting. But ...

How to restore encrypted backups

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

Data classification with Microsoft SQL Server and Azure SQL DB (GDPR, PII, HIPPA...etc)

This blog post will cover SQL Server on-premise or IaaS and Azure SQL DB and how to classify data in both. Let's start ...

Database migration: how to handle large tables

In the previous blog, we presented a simple database migration approach using Apache Nifi. Following our previous blog, ...

Backing up your MySQL instance physically with Docker

In a previous post, I had mentioned that I was doing a bit of digging into Docker in order to get a better grasp of the ...

Fun with Oracle Data Guard Broker

The beginning So, there we were attending to our jobs and tending to our customers when an emergency alert came in: a ...

Backup strategies in Cassandra

Authenticating Vault against LDAP for accessing MySQL through ProxySQL

Earlier this year, I was presented with the challenge of streamlining user access to MySQL, allowing users self-serve ...

Getting started with Orchestrator

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

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 some options that you can consider to model your cloud DW for better ...

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 from reaching ...

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

The basics If you're a Microsoft SQL Server DBA or developer and have not been introduced to the Microsoft Azure Data ...

BTRFS performance compared to LVM+EXT4 with regards to database workloads

Introduction In many database builds, backups pose a very large problem. Most backup systems require an exclusive table ...

Debugging MySQL on Docker

Problem Statement In a recent post, my colleague and teammate Peter Sylvester explained how we could customize MySQL's ...

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 knowledge I ...

Creating dynamic tasks using Apache Airflow

What's Airflow? Apache Airflow is an open source scheduler built on Python. It uses a topological sorting mechanism, ...

Deploying a private Geth network using Docker

So you’ve started developing an Ethereum project and TestRPC has worked wonderfully. Now you're ready to set up a CI/CD ...

Datascape podcast episode 26: a brief tour of the Google Cloud Platform

In episode 26 of the Datascape, we give you a whirlwind tour of the Google Cloud Platform, otherwise known as GCP. We ...