🚀

Richard Silveira RichardSilveira

🚀

Cloud Architect at Make | 3 x AWS Certified | 2x Azure Certified | Terraform Certified | MBA Specialist in Solutions Architecture, Node.js, and .NET

RichardSilveira / ContextCmder-Disable.reg

Created April 6, 2021 22:09 — forked from jojobyte/ContextCmder-Disable.reg

Cmder Context (Right-Click) Menu for Windows 7, 8 & 10

	Windows Registry Editor Version 5.00

	[-HKEY_CLASSES_ROOT\Directory\Background\shell\Cmder]
	[-HKEY_CLASSES_ROOT\Directory\shell\Cmder]

RichardSilveira / WarnUpFunctionCloudFormationResource.yml

Created November 14, 2020 12:19

Event Rule to warn up a lambda function

	WarnUpFunctionXXX:
	Type: "AWS::Events::Rule"
	Properties:
	ScheduleExpression: cron(0/10 10-01 * * ? *)
	Name: WarnUpFunctionXXX
	State: ENABLED
	RoleArn: arn:aws:iam::644846694994:role/my-role
	Targets:
	- Arn: !GetAtt XXXLambdaFunction.Arn
	Id: "TargetWarnFunctionXXX"

RichardSilveira / TimestreamTruckIoTSample.sql

Last active November 6, 2020 18:24

	SELECT
	truck_id,
	fleet,
	fuel_capacity,
	model,
	load_capacity,
	make,
	measure_name
	FROM "sampleDB".IoT
	GROUP BY truck_id, fleet, fuel_capacity, model, load_capacity, make, measure_name

RichardSilveira / LambdaFunctionListeningS3UploadFile_ReadStream.js

Created October 19, 2020 19:02

	exports.mys3UpdaloadEventhandler = async (event, context) => {
	console.log('event', event);
	console.log('context', context);

	const bucket = event.Records[0].s3.bucket.name;
	console.log('bucket', bucket);

	const key = decodeURIComponent(event.Records[0].s3.object.key.replace(/\+/g, ' '));

	try {

RichardSilveira / hyperlinkresponse.sample.json

Created September 23, 2020 17:48

Sample response from a random RESTful API with hyperlink

	{
	"departmentId": 10,
	"departmentName": "Administration",
	"locationId": 1700,
	"managerId": 200,
	"links": [
	{
	"href": "10/employees",
	"rel": "employees",
	"type" : "GET"

RichardSilveira / mariabdbserver-dev.cfn.yaml

Created August 21, 2020 20:32

Easy way to deploy a MariaDB Server based on AWS Marketplace AMI "MariaDB Server 10.3 on AmazonLinux" for DEVELOPMENT ONLY

	AWSTemplateFormatVersion: 2010-09-09
	Description: \|
	Deploy a MariaDB Server based on AWS Marketplace AMI "MariaDB Server 10.3 on AmazonLinux" for DEVELOPMENT ONLY
	Parameters:
	ServerKeyPair:
	Type: AWS::EC2::KeyPair::KeyName
	Description: Your Amazon EC2 Key Pair.

	VPCId:
	Type: AWS::EC2::VPC::Id

RichardSilveira / AthenaVPCFlowLogQuery.sql

Created July 2, 2020 10:43

	SELECT day_of_week(from_iso8601_timestamp(dt)) AS
	day,
	dt,
	interfaceid,
	sourceaddress,
	destinationport,
	action,
	protocol
	FROM vpc_flow_logs
	WHERE action = 'REJECT' AND protocol = 6

RichardSilveira / AthenaVPCFlowLogTablePartition.sql

Created July 2, 2020 10:35

	ALTER TABLE default.vpc_flow_logs
	ADD PARTITION (dt='{Year}-{Month}-{Day}')
	location 's3://<vpc-flow-logs-bucket>/AWSLogs/<account_id>/vpcflowlogs/<region>/<Year>/<Month>/<Day>';

RichardSilveira / AthenaVPCFlowLogTable.sql

Created July 2, 2020 10:24

	CREATE EXTERNAL TABLE IF NOT EXISTS default.vpc_flow_logs (
	version int,
	account string,
	interfaceid string,
	sourceaddress string,
	destinationaddress string,
	sourceport int,
	destinationport int,
	protocol int,
	numpackets int,

RichardSilveira / DeliverVPCFlowLogsPolicy.json

Last active July 2, 2020 10:26

Policy to be attached to a DeliverVPCFlowLogsRole with a Trusted relationship with "vpc-flow-logs.amazonaws.com"