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
Big Data Blog Posts That I Found Interesting – I am sure there are many others
Best Of Amazon AWS Big Data Blog https://aws.amazon.com/blogs/big-data/orchestrate-multiple-etl-jobs-using-aws-step-functions-and-aws-lambda/ https://github.com/aws-samples/aws-etl-orchestrator https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/best-practices.html#organizingstacks https://aws.amazon.com/blogs/big-data/build-a-data-lake-foundation-with-aws-glue-and-amazon-s3/ https://aws.amazon.com/blogs/big-data/orchestrate-apache-spark-applications-using-aws-step-functions-and-apache-livy/
psql to the rescue – a client program for postgreSQL or Redshift
Here are SOME links to some psql features: http://www.postgresqltutorial.com/psql-commands/ http://www.postgresqltutorial.com/postgresql-list-users/ http://www.postgresqltutorial.com/postgresql-describe-table/ The most current PostgreSQL docs. Read More
Preparing For The Amazon AWS Big Data Specialty Certification Test
Here is some of the material I used to prepare for the Amazon AWS Big Data Read More