Andrea Amorosi dreamorosi

Use the script above by making it executable (chmod +x convert.sh) and running it (./convert.sh).

If you want to add a page break use <<<, if you want to add syntax highlighting add :source-highlighter: rouge at the top of the Markdown file, it won't be rendered in Markdown but will be used by asciidoctor.

Get instance metadata on AWS EC2

curl -H Metadata:true "http://169.254.169.254/latest/meta-data/instance-id"

On Azure Windows VM

curl -H @{'Metadata'='true'} "http://169.254.169.254/metadata/instance/compute/vmId?api-version=2017-08-01&format=text"

Connect PowerBI / On-premises data gateway to AWS RDS PostgreSQL in VPC

TL;DR

Install Npgsql 4.0.10.0 or earlier (download .msi link here) with GAC enabled.
Add SSL Certificate used by PostgreSQL to Windows Trusted Root Certification; if you are on AWS you can download the bundle here, if not you'll have to bring your own or find the correct one.

Problem

Out of the box PowerBI is not able to connect to a PostgreSQL database; this limitation applies also to the On-premises data gateway that needs to be installed in order to connect to the RDS from outside of a VPC (more info here). Assuming that the host on which the two applications are running have network connectivity with the database there are a few steps needed in order to solve the following issues:

PostgreSQL Data Provider is not installed

Reduce video size (H.264)

docker run --rm -v $(pwd):$(pwd) -w $(pwd) jrottenberg/ffmpeg -stats -i input.mp4 -vcodec libx264 -crf 28 output.mp4

Use libx265 (H.265) for even more reduction (not compatible with Windows 10 without additional codec).

Create new Python virtual environment and manage dependencies

Requirements

python 2.7 or 3.x
pip
virtualenv

Create new virtual environment

The following command creates a new virtual environment named venv in the current directory, usually this will be your project's directory.

Install and configure webserver based on nginx with php 7 and fpm over socket configured plus a couple of utils.

While launching a new instance open the section Advanced details in step 3. Configure Instance paste this code that will clone this gist and run the install commands.

#!/bin/bash
yum install git -y
git clone https://gist.github.com/828861e850bbb14893ae144c28f39e0e.git /home/ec2-user/install
chmod a+x install/install.sh
bash /home/ec2-user/install/install.sh

	# /etc/nginx/conf.d/shiny.conf

	map $http_upgrade $connection_upgrade {
	default upgrade;
	'' close;
	}

	server {
	listen 80;
	listen [::]:80 ipv6only=on;

	{
	"Sid": "AllowListingOfBucketRoot",
	"Effect": "Allow",
	"Action": [
	"s3:ListBucket"
	],
	"Resource": [
	"arn:aws:s3:::{{BUCKET_NAME}}"
	],
	"Condition": {

	{
	"Sid": "AllowListingOfBucketRoot",
	"Effect": "Allow",
	"Action": [
	"s3:ListBucket"
	],
	"Resource": [
	"arn:aws:s3:::{{BUCKET_NAME}}"
	],
	"Condition": {

	{
	"Version": "2012-10-17",
	"Statement": [
	{
	"Sid": "ReadOnlyPermissions",
	"Effect": "Allow",
	"Action": [
	"lambda:GetAccountSettings",
	"lambda:ListFunctions",
	"lambda:ListTags",