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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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, […]
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 […]
