In most cases, troubleshooting EC2 issues starts with reviewing system logs through the AWS console, or by connecting to the instance via SSH/Session Manager, but what happens when an instance fails to launch? The following is a sample error message observed from an instance which had failed to launch: State…

The build/push of docker images to ECR using Terraform can be accomplished using the null provider. Depending on the version of Terraform you have running, a more favourable (or “modern”) alternative would be to use providers/kreuzwerker. With that said, the null provider can make for a good fallback option. This…

The AWS CLI subcommand assume-role-with-saml can be utilised to retrieve temporary credentials when accessing SAML2-based Identity Provider (IDP) that has been federated to AWS. Several third party login “helpers” are available for this purpose, for example, aws-google-auth can be used when Google is the federated IDP. However, these tools are…

According to MS official documentation for WSL, systemd support can be enabled for WSL version 0.67.6+. The WSL blog states that systems running Windows Insiders build can upgrade to the latest WSL version by downloading the update from the Microsoft Store. If you’re not running Windows Insider, you can still…

An introduction to Vantage Native Object Store (NOS) has been covered in a previous post, where the following code sample was used to query csv data in an S3 store (by using the READ_NOS operator). SELECT TOP 5 * FROM READ_NOS ( USING LOCATION ('/s3/my-private-surface-water-data-store.s3.us-west-1.amazonaws.com/CSVDATA/09380000/2018/06/27.csv') …

Native Object Store (NOS) is a Teradata feature which allows for data-in-place operations against a variety of external store types, including S3. By using inbuilt SQL functions and operators, an end user is able to perform read/write operations. …

The WSL Preview Edition (available via the Microsoft Store) introduces an additional argument for directly working with virtual disks. WSL from the Microsoft Store introduces a new argument to directly mount a VHD: wsl — mount — vhd <pathToVHD> This post describes the procedure for adding a VHD to an…

This article primarily focuses on establishing connectivity between Guitar Pro and a Digital Audio Workstation (DAW) by using a virtual MIDI loop device as a conduit for transferring MIDI data between the two programs. …

This article provides an approach to streaming query output from RDS Postgres to an S3 CSV file via a NodeJs Lambda function. The process uses pg-copy-streams and the query results to create a data stream which is piped to S3 using the aws-sdk. Alternatives to removing the function’s dependency on…