This is the second in my series analyzing data centirc markets. Read part one: Demystifying the Database Market in 2025. According to Gartner (2024), by 2027, 80% of data and analytics governance initiatives will fail due to a lack of a real or manufactured crisis. This is a pretty loaded statement, because it tells us […]
Demystifying the Data Governance Market in 2025 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 »
The Database Management System Market in Plain Language Your job, unfortunately, depends on a database doing what it’s supposed to: record the firm’s relationship to money in a structured format. If that database went away the world would absolutely collapse. I wish I was kidding, but think about it: if your corporate ERP system goes
Demystifying the Database Market in 2025 Read More »
This blog is the first part of a series exploring the database technical landscape. Databases are typically layers of software on top of storage that provides structure to data in order to extract information from them. Fun fact, data is a collection of facts while information puts those facts into context. There are multiple layers
Technical Concepts : Database Models Read More »
I first began working with databases when I was an undergrad doing Computer Science. There was a module that ran tutorials for data manipulation against an Oracle database using SQL. I remember what I was thinking when trying to figure out how to get the correct output : “I don’t understand, why won’t it work!”.
A history of myself, DOES and data 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 »
Caching is used in hardware and software to shorten operational response times for data with a high usage frequency. CPU’s implement caching through the use of smaller and faster memory on or close to the processing unit where data can be retrieved and processed more quickly than in main memory. For persistent storage like hard
Introduction to Storage Caching Read More »
MySQL and MariaDB are two very popular database engines (Source – DB-Engines Ranking). Both are open source (licensed as GPLv2 or proprietary for MySQL or LGPL for some scenarios with MariaDB) which allows for abundant support , lower software costs and no vendor lock-in. There are many reasons an organization would want to make use
MySQL and MariaDB Replication Read More »
There are a number of ways in which data protection/data mobility can be done with MySQL. The documentation splits backups into two categories. Physical Backups – Raw copies of directories and files which store database contents Logical backups – Logical backups save information in the form of reproducing the database object structure to the point
MySQL Backup and Recovery Read More »
This is the final part of the blog series about moving seamlessly between SAP HANA hosting types using storage where the concepts and scenarios in Part 2 : pHANA on-premises migration techniques and Part 3 : pHANA to vHANA and vHANA to pHANA will be applied to showcase how a truly hybrid cloud environment could
SAP HANA Data Mobility Part 4 : Hybrid Cloud Read More »
SAP® Migrations are a daily part of any SAP BASIS administrator’s life and possibly one of the most meticulously planned processes which can happen in the lifecycle of an SAP landscape. The migration alone could be to move one or all of the SAP applications , data and technology to either the same or totally
SAP HANA Data Mobility Part 1 : Introduction Read More »
In this part of the blog series about moving seamlessly between SAP HANA hosting types using storage the following data mobility scenarios are explored: SAP HANA deployed on bare-metal server(s) (pHANA) being migrated or copied to a virtual machine(vHANA) using VMware Virtual Volumes(vVols) SAP HANA deployed on a VMware virtual machine being migrated to bare-metal
SAP HANA Data Mobility Part 3 : pHANA to vHANA and vHANA to pHANA Read More »
In this part of the blog series about moving seamlessly between SAP HANA hosting types using storage the following data mobility scenarios are explored: Copy an SAP HANA Instance to the same or a different FlashArray using storage snapshots and Asynchronous replication Move an SAP HANA Instances persistent storage to a different FlashArray non-disruptively using
SAP HANA Data Mobility Part 2 : pHANA on-premises migration techniques Read More »
The release of SAP HANA 2.0 SPS05 brings some great new capabilities to the platform , among them Native Storage Extension support for Scale Out Landscapes , significant improvements to the startup initialization of hybrid LOBs and support for having an NFS server for the hana-shared directory on the Master host of a scale out
Using hdbpersdiag To Check For Volume Corruption Read More »
While creating and publishing the SAP HANA scripts , I wanted to bring some of the excellent design aspects of Pure Storage® products to customers running SAP HANA on FlashArray//X. Some of these excellent design aspects include a very well defined and easy to use REST API , the software developer kits (SDK’s) for Powershell
Updated! SAP HANA Scripts with support for vVols Read More »
One of the recent projects I have been very proud to deliver was the creation of an open source repository on GitHub, containing scripts to help customers automate SAP HANA storage operations with common scripting languages like Microsoft PowerShell and Python. The initial scripts committed to this public repository will help customers create application consistent
Updated! SAP HANA Scripts with recovery automation Read More »
Ever since I began working with enterprise storage arrays such as Pure Storage FlashArray//X, storage snapshots have been a constant presence. In my journey of fully understanding the various aspects of snapshots, I found myself looking to Wikipedia and found an excellent definition for a snapshot: “In computer systems a snapshot is the state of
FlashArray Snapshot Consistency and SAP Read More »
Virtual volumes(vVols ) have changed the way organizations think about how virtual machine storage operates.When using vVols, a layer of complexity is removed to allow the virtual infrastructure administrator to deliver more precise storage service levels and have more direct control over how storage is consumed by virtual infrastructure. Cody Hosterman blogged about the Introduction
Configuring SAP HANA Scale Out on VMware with vVols Read More »
While writing and developing content for SAP HANA on Pure Storage® FlashArray™ or Pure Cloud Block Store™ (CBS), I have developed some scripts that speed up some of the operations which organizations using SAP HANA on Pure Storage products could also make use of. To that end, I have created a repository for SAP HANA
New! SAP HANA Scripts for Automating Storage Operations Read More »
Every so often I need to configure VERITAS Netbackup to backup one of my SAP HANA databases and sometimes I return to my notes on the process to remind myself how it’s done. The most recent time when using block storage volumes on FlashArray//C as the target for backup data , I decided to fully
Configuring VERITAS Netbackup using FlashArray//C for Scale Up SAP HANA Read More »
During the last year I have persistently explored how the SAP® HANA® in-memory data platform can be protected. Some of these explorations range from working with storage snapshots , protecting business operations through the use of ActiveCluster™ and creating resilient environments through the combination of both concepts. Recently I have embarked on creating demonstrations on
Protecting SAP HANA with FlashArray//X and SAP HANA Cockpit Read More »
I have previously blogged about SAP HANA NSE and the impact of using it with Pure Storage products. One of the key areas I believe differentiates NSE from other warm data techniques is the inclusion of a component to analyse and provide recommendations on if data should be set to use NSE , or not.
Using the SAP HANA Native Storage Extension (NSE) Advisor Read More »
Data growth and managing the costs involved with it are becoming an increasingly important aspect of any deployed business system. When addressing this issue with SAP HANA there are a range of considerations which need to be taken into account: License cost (SAP HANA is licensed on used memory capacity and feature usage) Hardware cost
Configuring SAP HANA Extension Node Read More »
Have you ever had one of those days where no matter how much time you spend on a problem it just won’t work and the solution alludes you? This could be putting together a programming pattern, installing a new system or setting up any basic application. It seems everyone who has ever touched a computer
Simple solutions for complex problems Read More »
