Connecting AWS Lambda to Microsoft SQL Server Using PyODBC

In this guide, we’ll walk you through the steps to connect AWS Lambda to Microsoft SQL Server using PyODBC. PyODBC leverages a Driver Manager called unixODBC, which allows the loading of different ODBC drivers published by Microsoft for various versions of SQL Server. Before you start, ensure you have the following: These are the step-by-step … Read more

Recovery Steps for EC2 Instances Affected by the CrowdStrike Global Outage

Recovery Steps for EC2 Instances Affected by the CrowdStrike Global Outage

Recently, a global outage has impacted CrowdStrike and Microsoft services. If you’re using AWS cloud services, this recovery procedure will help you address issues with EC2 instances affected by this outage. The outage has specifically affected Windows EC2 instances, and we know it’s critical to restore your systems quickly. Fortunately, there are two main temporary … Read more

How to Use SQL Joins and Conditional Statements in PostgreSQL

How to Use SQL Joins and Conditional Statements in PostgreSQL

In this blog, we will explore some fundamental SQL concepts using sample tables and records within a PostgreSQL database, as established from this article. We’ll cover INNER JOIN, LEFT OUTER JOIN, and the CASE WHEN ELSE END statement. Let’s start by setting up our sample tables and data. Sample Tables and Data We will create … Read more

How to Access PostgreSQL in Ubuntu WSL with pgAdmin 4

How to Access PostgreSQL in Ubuntu WSL with pgAdmin 4

Working with databases through a command line interface can be efficient, but sometimes you may prefer using a graphical user interface (GUI) to manage your databases. If you have PostgreSQL installed on your Ubuntu Windows Subsystem for Linux (WSL) and want to access it using a GUI client from your Windows environment, follow these organized … Read more

How to Install PostgreSQL on WSL Ubuntu 22.04

How to Install PostgreSQL on WSL Ubuntu 22.04

PostgreSQL is a powerful, open-source relational database management system widely used for its robustness and performance. If you’re running Ubuntu 22.04 on Windows Subsystem for Linux (WSL), you can easily install and configure PostgreSQL to leverage the power of both Windows and Linux environments. In this tutorial, we’ll guide you through the step-by-step process of … Read more

Resolving Internet Connection Issues in WSL 2 on Ubuntu 20.04

Resolving Internet Connection Issues in WSL2 on Ubuntu 20.04

Users of Windows Subsystem for Linux 2 (WSL 2) might sometimes find themselves unable to connect to the internet from their Ubuntu 20.04 environments. This can be frustrating, especially when trying to install packages or pull updates. In this post, we’ll explore the root cause and provide a solution to resolve this common issue. Example … Read more

How to Make Resolve Config Changes Permanent in WSL 2

How to Make Resolve Config Changes Permanent in WSL 2

When working with Windows Subsystem for Linux (WSL) 2, users often encounter an issue where changes made to the /etc/resolv.conf file are not persistent after a reboot. This can be frustrating, especially for developers who need to maintain specific configurations for networking or DNS settings within their Linux subsystem. The Root Cause The primary reason for this … Read more

How to Upgrade Terraform to a Specific Version

How to Upgrade Terraform to a Specific Version

When working with infrastructure as code, using the right version of Terraform is essential for compatibility and stability across your projects. In this blog post, we’ll explore a common challenge faced by many developers: upgrading Terraform to a specific version. This task can be crucial when managing multiple environments or when a new version introduces … Read more

How to Configure Terraform on Windows 10 WSL Ubuntu for AWS Provisioning

How to Configure Terraform on Windows 10 WSL Ubuntu for AWS Provisioning

Provisioning infrastructure on AWS with Terraform is efficient and allows for Infrastructure as Code (IaC) practices. In this tutorial, we will walk through the process of setting up Terraform on Windows 10 using the Windows Subsystem for Linux (WSL) with Ubuntu. Step-by-Step Guide Step 1. Enable WSL and Install Ubuntu To enable WSL and install … Read more