Paraccel – Script to run the various regular housekeeping jobs for a given database

The credit for this script goes to Graham Mossman ### ### housekeeping.bash ### ### Usage: ### ./housekeeping.bash ### ### Description: ### Script to run the various regular housekeeping jobs for a given database. ### source /home/paraccel/.bashrc # this…

Read More »

Troubleshoot Redshift / Paraccel COPY command load errors

The scripts below can be used on both Amazon Redshift and Actian Matrix (Paraccel) for operations related to COPY commands. Number of rows inserted by each succesful COPY command SELECT starttime, querytxt, lines_scanneD FROM stl_query NATURAL JOIN stl_load_commits…

Read More »

How to Prepare for Professional Scrum Master I (PSM I) Exam

Details of the certification exam: Professional Scrum Master Assessment For a quick intro of the Scrum framework look at these videos: The Scrum Framework Explaining Scrum in less than 120 Seconds Learn Scrum in 7 Minutes For a…

Read More »

Change Data Capture CDC – Decrypting the __$update_mask

Just thought of posting this in case someone else is looking at a way to decrypt the __$update_mask. If you don’t know what an __$update_mask is then you should go through any one of the following articles first:…

Read More »

Baked Eggs in Avocado

30 minutes, 576 calories, 1 serving Ingredients 40 g hummus 2 whole eggs (~100 g) 1 avocado (~200 g) 50 g cherry tomatoes optional: a tiny bit of salt optional: 1 tsp black pepper optional: 2 g chives…

Read More »
Bitnami