Author: Peter Whyte
-
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.…
-
Removing Quotes from a CSV File with PowerShell
This post explains how to remove quotes from a CSV file using PowerShell, a common requirement when working with CSVs that include unnecessary or problematic quotes. Whether you’re cleaning up data for easier processing or addressing formatting issues caused by quotes, this post will show you how to…
-
“.ps1 cannot be loaded because running scripts is disabled on this system” PowerShell Error
Encountering this error? It’s caused by restrictive execution policies that block scripts for security reasons. This guide explains the issue and provides actionable solutions. PowerShell restricts script execution by default. Running a script like my example cdk.ps1 may trigger the following error message: Script.ps1 cannot be loaded because…
-
Creating a Linked Server with a MySQL Database
This is my third Linked Server demo post, and this time, we’re connecting to a MySQL database. Here’s a simple diagram of the setup covered in this post, configuring a Linked Server to a MySQL Database: For this setup, I’ve covered it all in previous blog posts: –…
-
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…
-
Testing Connectivity to Remote Server Ports with PowerShell
This post contains a demo for how to check if a port is open using PowerShell, whether you are on the latest or older versions of Windows. All admins need to know how to test connectivity to remote server ports. In fact, all software developers and other technical…
Categories
- Linux & WSL (26)
- Microsoft SQL Server (103)
- Other (13)
- PowerShell (51)
- Windows Server Admin (45)
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) (16) 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 (21) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (18)