Hands-on technical implementation and testing
Oracle ranks #1 on the DB-Engines database popularity ranking, ahead of MySQL, SQL Server, and PostgreSQL. Running Oracle benchmarks alongside SQL Server in my day-to-day testing made perfect sense from the start, but HammerDB-Scale v1.0 focused on getting SQL Server working properly first. Version 1.1 adds Oracle support with the same parallel orchestration framework that […]
Oracle Database Support for HammerDB-Scale Read More »
You will end up here: v$dnfs_servers returns no rows. You’ve checked everything. The library is linked. The alert log shows dNFS loaded. Your oranfstab is syntactically perfect. The NFS mounts are there. And you’re convinced it’s broken, I was too. I spent three hours proving dNFS was configured correctly while simultaneously proving it wasn’t working.
Schrödinger’s dNFS: The Empty Row Mystery Read More »
Your storage vendor claims 500K IOPS. Your server vendor promises 128 cores of “enterprise-grade performance.” Your hypervisor can “easily handle” 50 VMs. Your network fabric has “plenty of headroom.” Then you consolidate eight production databases onto the platform and everything falls over at 3 AM on a Tuesday. What happened? Nobody actually tested what happens
Stress Testing Consolidated Platforms with Database Workloads Read More »
This is the unmanaged experience of Apache Spark in 2025, and it is a Screen Play in length, you were warned! P.s. – Netflix greenlight me! A few weeks ago, I dove deep into Apache Spark through hands-on implementation of a Customer 360 use case, using the medallion pipeline processing architecture (Bronze → Silver →
Apache Spark in 2025: Handle with Gloves Read More »
There are many database benchmarking and testing tools that can be used to understand how a system might behave under specific circumstances. Each one of these has a specialism, some of them are designed for unit testing while others are workload oriented. After several years working towards this goal I am excited to announce my
Simple Database Testing with D.O.E.S Read More »
Recently while doing some bits and pieces around the containerization of various databases I found myself deploying RedHat® OpenShift®. I found in my case there were a number of caveats to make everything work as intended and so I decided to see if a step by step of my experience could be helpful to others.
Deploying an OpenShift Cluster on VMware vSphere Read More »
This blog post is focused on the different datasets I have designed to evaluate Pure Storage® DirectMemory Cache with various databases like SAP HANA, MySQL and MariaDB. More information on the results can be found in the blog posts Reducing costs for SAP HANA with Pure’s DirectMemory Cache and Accelerate MySQL Read Scale with DirectMemory
Evaluating Storage Read Cache for Different Database Designs Read More »
This post is focused on providing a foundation for the structures and designs of a relational database. Tables/entities The typical structure of a table is a set of rows , each with its own data in a specified column. This table is a list of customers with their first names ,last names , addresses and
A Brief Introduction To Database Structures and Design Read More »
