Gmail Clean-up
Not so much Data & Database, but useful advice for managing a Gmail account once the storage gets a bit full (and Google suggests paying for storage).
This one little trick will save you up to 79% on your cloud refresh costs
Yes, the title is clickbait, but the savings are real! The approach can be applied to save money on any cloud data infrastructure. The saving in question applies to regular refreshes, not other data processes (more on that in the future).
A technique for sharing dbt demo projects
An approach for creating a dbt demo project which can be shared and run easily by any developer. From an empty directory, to dbt run in under 5 minutes.
Using eclipse IDE for dbt development
I’ve been using eclipse as an IDE of choice with dbt for a couple of years, here is how I configure it for working with dbt projects.
Introducing: Dirty Master Data Management Application
This is a side project of mine, something to keep me out of mischief at home. My aim for this project is to be an example/template/starting point for using flask for a quick (and dirty) approach to a Master Data Management (MDM) application AKA a Data Warehouse Management Application (DWMA).
Dates In SQL Server
Some time ago what started as one article on dates and their value, turned into a mini-series (nearly as engaging as The Queens Gambit). I kept finding more to say about dates and examples to give. I’m now pulling them together with a little narrative.
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.