Python – Getting all the methods available to a data type
>>> myStuff = ‘Hello world’ >>> type(myStuff) <class ‘str’> >>> dir(myStuff) [‘capitalize’, ‘casefold’, ‘center’, ‘count’, ‘encode’, ‘endswith’, ‘expandtabs’, ‘find’, ‘format’, Read More
General Meditation Methodologies – calm and focus the mind
Repeating a mantra or focusing on breathing etc. to focus the mind and at the same Read More
Your iPhone or iPad not recognizing your touch? Do you have dry hands?
Apple doesn’t publicize this one much… they must be embarrassed, is it affects a large # Read More
Redshift PL/SQL well I should say PL/pgSQL is out but what do you use as an authoring client?
What do I use so far for PL/pgSQL development – Aginity and psql. psql is the Read More
Redshift how to show who I am currently connected as
Redshift how do I show who I am currently connected as? Well that is easy enough Read More
Generating Oracle DDL with SQLcl
This one is powerful enough that I would just like to reference Jeff Smith’s post on Read More
Is you linux password expired?
chage -l <username> Yes, usually when you login, you will be prompted to change your password Read More
Want to Move Your Redshift Groups, Users and Assign Them As You Did in Another DB
# spool this stuff to a file from your source db, then run the spooled SQL Read More
AWS Diagrams Galore From awsgeek.com
https://www.awsgeek.com/ Current as of 2018
Developing and Hosting Web Applications Cost Effective – With Flask or Django and Lambda on AWS
Developing and Hosting Web Applications Cost Effective – With Flask or Django and Lambda on AWS Read More
Crontab Overview
Linux Crontab Syntax # write existing crontab to file crontab -l > crontab.out # put a Read More
Using AWS CLI
AWS CLI Basics: Assuming you have aws cli setup – if you are using an ec2 Read More
Redshift Grant Read On PG_CATALOG Objects To Normal / Non Superusers
Redshift is based on a version of PostgreSQL that only allows SuperUsers to see pg_catalog objects. Read More
Analyzing How Your Redshift Cluster is Performing Queries and Storing Data
Analyzing How Your Redshift Cluster is Performing Queries and Storing Data Useful Queries Space Used – Read More
Federated Active Directory Integration With Redshift – other blog posts and documentation reference
https://aws.amazon.com/blogs/big-data/federate-database-user-authentication-easily-with-iam-and-amazon-redshift/
Verizon’s secret $40 unlimited plan is now available to everyone – you just need an iPhone
https://www.yahoo.com/tech/verizon-secret-40-unlimited-plan-now-available-everyone-182849186.html originally posted on bar.com Earlier this year, it emerged that Verizon is very stealthily funding Read More
Redshift static (reboot required) versus dynamic – no reboot – parameters
The following WLM properties are dynamic: Enable short query acceleration Maximum run time for short queries Read More
Redshift Blog Post With a Performance and Cost Lean…
Some of this is a repeat for my own value from another of my blog posts Read More
Redshift and PostgreSQL Schemas Versus Owners
Coming from an Oracle background where schemas are roughly equivalent to owners the important differences between Read More
Redshift create plain user, superuser, createdb user etc…
select * from pg_user_info where usename like ‘mcost%’; create user mcost with createuser password ‘1234Mike’; create Read More