SQL DBA Blog

Category: Linux

Linux Blog Archives, by Peter Whyte (SQL Database Administrator). Includes random Linux posts, and Windows Subsystem for Linux (WSL).

  • How To Install Windows Subsystem for Linux (WSL)

    To install WSL (Windows Subsystem for Linux), we first enable the WSL Windows Feature using PowerShell, then install WSL Linux Distributions via the Microsoft Store. This post will help guide you through enabling and installing Windows Subsystem for Linux (WSL) on your local Windows computer. WSL allows Windows…

    Read More

  • How To Change From WSL2 to WSL1

    This is a post on how to change a Windows Subsystem for Linux (WSL) Distribution from running on Version 2 to Version 1. WSL has two versions, the latest (2), and the original version (1). You can have many different Linux Distributions installed on your machine, and you…

    Read More

  • How to Install Postgres on Ubuntu 20.04

    This post is a short note on how to install Postgres on Ubuntu 20.04. I’m doing this in WSL, however this shouldn’t make any difference if you’re on the same Ubuntu version. First, lets update our local packages by running the following apt command – This Postgres installation…

    Read More

  • How to Manage S3 Buckets with AWS CLI

    This is a post on how to help manage S3 Buckets with AWS CLI, and to help explain some local Operating System (OS) considerations when running such commands. First of all, you will need to be authenticated to your AWS Account and have AWS CLI installed. I cover…

    Read More

  • How to Install & Configure AWS CLI on Ubuntu

    This guide will walk you through the steps to install and configure AWS CLI version 1 on Ubuntu (20.04). Topics Covered: 1. Updating Local Packages2. Installing AWS CLI on Ubuntu3. Checking Installed AWS CLI Version4. Configuring AWS Profile5. Running AWS CLI Commands 1. Updating Local Packages To start,…

    Read More

  • How to Install Ubuntu 20.04 on WSL

    This guide shows how to install Ubuntu 20.04 on WSL (Windows Subsystem for Linux). Before installing a WSL Linux distribution you should have already enabled WSL on your computer. All WSL Linux distributions are available for download in the Microsoft Store. This is the easiest way to install…

    Read More

  • How to Uninstall a Linux Distro in WSL

    If you want to remove a Linux distro from your Windows Subsystem for Linux (WSL) installation, you can use the wsl –unregister <distro-name> command to unregister it. This blog post shows a quick demo of uninstalling a WSL distro. Keep in mind that unregistering a distro will permanently…

    Read More

  • How to Set Default WSL Distribution

    This guide contains a demo on how to set the default Windows Subsystem for Linux (WSL) distribution on a Windows computer. This is particularly useful if you have multiple WSL distributions installed and need to manage various Linux environments on Windows. There are two parts to this:> Check…

    Read More

  • Change Git Remote URL to SSH from HTTPS

    This post is a guide on how to change Git from using SSH to HTTPS for authentication. Using SSH for your version control system is more efficient as we do not have to enter a password every time we need to contact the remote repository. You should have…

    Read More

  • Setting up SSH Keys in WSL

    Setting up SSH keys on Windows is generally done via OpenSSL or Putty. We can set this up and have quick authentication to places like GitHub or Bitbucket. But, we are also able to rely on a Linux distro in WSL for our SSH. If you are developing…

    Read More

Recent Posts

Categories

– AWS
– DBA Stories
– Linux
– MySQL
– Other
– Postgres
– PowerShell
– Redshift
– SQL Server
– Windows Server

Tags

Always On Availability Groups (AAG) (3) Certificates & Encryption (3) Change Data Capture (CDC) (2) Database Admin (71) Database Backups & Recovery (12) Database Mirroring (2) Deleting Data (1) Error Messages (4) Git Commands (5) Importing & Exporting Data (2) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (10) Microsoft Patching (2) PowerShell Scripts (1) SQL Server Agent (4) SQL Server Database Files (1) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (14) SQL Server Network Connectivity (2) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance (5) SQL Server Permissions (1) SQL Server Processes (5) SQL Server Replication (1) SQL Server Scripts (12) Windows Admin (21) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (20)