RSSAmplifier

Blog

My Adventures in Coding

Just another software developer stumbling along...

myadventuresincoding.wordpress.comRSS feed ↗10 posts

Latest posts

Linux – How to Format and Mount a Data Drive

I work in Linux every day, however it is not often that I have to setup a new data drive. As a result I always need to look up the commands. So I decided to create this post just as a quick reference. Note: For this example I was using Rocky9 Linux. View the Existing [ ]

Python – How to Send an Email with an Attachment

Every once and a while when I am working in Python I need to send an email, often with an attachment. So I decided to just write up a simple method I can keep handy for future reference. This example method allows for optional lists of CC and BCC emails as well as an optional [ ]

SQL Server – How to Rebuild Indexes Online on Large Partitioned Tables

Rebuilding a Partitioned Index I regularly work with some very large tables that use SQL Server Partitions. We use daily, weekly, or monthly partitions based on the frequency of the data we are receiving. Just to give you an idea of what I am dealing with, I have one table that uses daily partitions and [ ]

RabbitMQ – How to Install RabbitMQ on Windows 10

In test and production environments I run RabbitMQ on Linux, but my development environment happens to be windows. I need to have a local instance of RabbitMQ. Since RabbitMQ supports Windows the setup is fairly straight forward, but there are some potential problems you can run into. This article is meant as a quick start [ ]

OpsCenter – Setting up Authentication with Roles and Users

DataStax OpsCenter is a handy tool. However, since it provides the user with a lot of operations that if done accidentally could be very destructive (i.e., truncate table), it is a very good idea that when you install OpCenter, you immediately do three things: Enable Authentication Change the admin password Create user accounts with restricted [ ]

Redis – How to Setup a Six Node Redis Test Cluster in Ubuntu on Windows 10

I work on several applications that use Redis. In production those applications all use six node Redis clusters that run on Linux. However, my developer workstation is a Windows 10 machine on which I only have a single node instance of Redis running. I really wanted to have a six node Redis cluster to test [ ]

RabbitMQ – How to join a node to a cluster when you get the error: incompatible_feature_flags

If you are reading this post it is because you have received the dreaded incompatible_feature_flags error when trying to join an upgraded node or a newly created node to an existing RabbitMQ cluster. I will describe the scenario that got me into this situation and the solution I used to resolve it. Scenario I have [ ]

RabbitMQ – How to do a Rolling upgrade in a Cluster (Version 3.8+)

Recently I had the task of upgrading several RabbitMQ clusters that were each running at least version 3.8 of RabbitMQ. We wanted to roll out each upgrade with no downtime. Overall, the documentation provided by RabbitMQ on Upgrading, Rolling Upgrades, and Feature Flags is generally pretty good. The problem in the documentation is it mostly [ ]

Cassandra – Recovering Deleted Data with SSTabledump

If you accidentally delete a small amount of data from a single partition, you have a window of opportunity to recover that data before it is permanently removed. Since Cassandra is an immutable database, meaning data files are never updated, instead your delete is written to the database in a new file as a Tombstone, [ ]

Cassandra – How to Run DataStax Enterprise in Ubuntu on Windows 10

Previously I had been working with open source Apache Cassandra, but now I mostly work with DataStax Enterprise (DSE) Cassandra. The one downside is that since my developer workstation is Windows 10, only Apache Cassandra is supported on Windows, while DSE Cassandra is not. In the past when I had Linux only software I wanted [ ]