Category: Linux & WSL
Linux & Windows Subsystem for Linux (WSL) Blog which includes useful guides and troubleshooting tips, written by an experienced Microsoft SQL Server DBA, Peter Whyte.
-
How to Change Git Remote URL to SSH from HTTPS
This guide walks you through changing your Git authentication method from HTTPS to SSH. Using SSH eliminates the need to enter a password each time you interact with a remote repository. Before proceeding, ensure you have SSH keys set up. If you haven’t done this yet, check out…
-
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…
-
Create a Link Between Local Windows Files and WSL
Creating a link between local Windows files and WSL (Windows Subsystem for Linux) is a useful way to share files between the two environments. In this guide, I’ll show how to link a folder in Windows to your WSL instance using the ln command, and also explain how…
-
Access Local Files from Windows Subsystem for Linux (WSL)
Accessing local Windows files from a WSL distribution allows integration between workflows, our local Windows environment and (WSL) Linux environments. This is done by navigating to the /mnt/c/ directory within your WSL Linux terminal. Alternatively, you can enter WSL directly from any Windows directory using a terminal. Both…
-
Reinstalling WSL Distributions
This guide walks you through reinstalling a WSL (Windows Subsystem for Linux) distribution via command line. This can be useful if you want to reset your WSL environment for a fresh start. Before proceeding, ensure you back up any important work to Git or another storage solution. 1.…
-
Check & Restart SQL Server Services on Linux
As of the 2017 Edition of SQL Server we have been able to install SQL Server on Linux. Linux will likely be more of an unfamiliar environment for traditional Microsoft SQL DBAs. This guide will walk you through how to check the status of SQL Server services and…
-
How to Install SQL Server on Linux
As from SQL Server 2017, we now have support for running our favorite RDMS on Linux, as well as Windows! This guide walks you through installing SQL Server 2019 on Red Hat Linux, setting up command-line tools, and connecting both locally and remotely. Hope it helps! Topics Included:…
-
How to Install Firewalld on Linux
Firewalld is a firewall management tool that simplifies rule configuration for Linux systems. It dynamically manages firewall rules, supports zone-based configurations, and integrates with D-Bus. In this post I’m showing how to install Firewalld on an Amazon Linux 2 EC2 Instance. Hope you find this useful! Installing Firewalld…
Categories
- Linux & WSL (26)
- Microsoft SQL Server (103)
- Other (13)
- PowerShell (50)
- Windows Server Admin (44)
Tags
Always On Availability Groups (AAG) (4) AWS (4) AWS Redshift (6) Database Admin (72) Database Backups & Recovery (14) Database Mirroring (2) Error Messages (5) Failover Cluster Instances (FCI) (1) Git Commands (6) Importing & Exporting Data (2) Linked Servers (3) Linux Administration (2) Logging & Monitoring (1) Microsoft Patching (2) MySQL (4) Postgres (6) PowerShell Scripts (2) SQL Certificates & Encryption (3) SQL Server Agent (5) SQL Server CDC (2) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (17) SQL Server Networking (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance Tuning (6) SQL Server Processes (SPIDs) (7) SQL Server Replication (2) SQL Server Scripts (13) SQL Server Security (4) SQL Server Storage (10) Windows Admin (20) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (18)