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. For example, table operator READ_NOS can be used to read/search the contents…

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…

Testing of playbooks for AWS deployments can be a challenge for an application developer. Within controlled environments, playbooks are generally executed via workflows/pipelines managed by DevOps teams. The combination of Localstack and Ansible provides an app developer the capability for preliminary local/mock testing of playbooks without incurring AWS billing costs. …

What follows is a walkthrough outlining the steps involved in implementing AWS cross-account access to an encrypted S3 bucket. The following is a summary which describes the scenario used for the walkthrough: An S3 bucket, s3://account-a-bucket, is to be created in account-a and made accessible to an external AWS account…

In a previous post, I documented learnings from setting up a local Devops environment. This article aims to apply a potential use-case for this environment by including support for Terraform. The following overview of the goals to be achieved should help you in deciding whether to read on: Tweak/expand the…