Just as important as the work we are committing to…
The legendary “Warren Buffett” advice, that is just as important as the work we are committing to.
Checking tablespace Usage & Availability in Oracle
View each tablespace in oracle and the amount of allocated disk space used.
DaVinci Resolve & Cloud Computing: Using AWS For Video Editing
This covers cloud computing and video editing which is a hobby of mine. As AWS offers Nvidia hardware, I want to leverage it to run DaVinci Resolve, my video editor of choice.
Ubuntu Server Migration: Moving my WordPress blog to a new DigitalOcean Droplet
This is how I migrated form my old droplet to a new Ubuntu 20.04 droplet.
How to move tables, indexes and partitions to a different tablespace in Oracle
I had a case where I needed to move objects to a new tablespace, quite a few objects. As there was a lot of objects (tables, indexes and partitions) I decided to automate the code creation from the database metadata. Moving Objects To A New Tablespace The first thing to understand is how to move…
Presentation; Unleash your Inner Rockstar!
Most of us love a good ted talk! We sit in awe not just at the idea, but how the idea is packaged and presented. Not every presentation has to echo Steve Jobs unveiling the iPhone, or Bill Gates showing the path to a better world through health initiatives. Sometimes people just want the facts…
Dates In SQL Server: Creating Date Range Batches
I found a scenario where I wanted to identify groups of consecutive dates over a larger date range.
Storytelling & Encouraging Change
When working with teams and stakeholders, communicating a vision is paramount to success. Working in technology it’s easy to focus on the technological advantages and forget to include everyone on the journey. A key to getting wider business support on projects requires engagement with stakeholders, business managers and end users of the planned solutions. It’s…
Visual Studio & diff Tools
A diff tool (software to compare the difference between two text files) is a valuable asset to those of us who spend more than a healthy portion of the day looking at text files. Mostly this is to understand, what is different between the original and new version of some code. Some time ago, I…
RLIKE in hive: Filtering with regular expressions
As I previously did a blog post on Querying SQL Server with something LIKE a regular expression (Using simple regular expressions in a LIKE statement), I thought I would use that as a segue into Apache Hive and HiveQL. Because Hive and therefore HiveQL is built using Java, it has the full power of Java regular…