SQL DBA Blog

Author: Peter Whyte

Creating Folders (If Not Exists) with PowerShell

August 9, 2022

If you need to create folders or subfolders in PowerShell only when they don’t already exist, this quick script will help. The script uses Test-Path to check if the folder exists before running the New-Item command. This snippet is ideal for anyone searching for a fast and reliable…
Read More
Advanced File and Folder Creation with PowerShell

August 7, 2022

This post contains an advanced guide for creating and managing files and folders in PowerShell. It builds on the basics introduced in my previous post, PowerShell Guide: Creating Folders and Files, and includes more techniques useful for a DBA or Sysadmin. Contents: 1. Creating New Files and Folders2.…
Read More
How to Restart Windows Subsystem for Linux (WSL)

August 4, 2022

If your Windows Subsystem for Linux (WSL) instance encounters errors or you’ve updated the .wslconfig file (e.g., to modify memory limits), restarting your WSL distributions may be necessary. This guide demonstrates two effective methods for restarting WSL distributions: > (Preferred Approach) Run the WSL –Shutdown Command > (Old…
Read More
How to Upgrade WSL from Version 1 to Version 2

August 2, 2022

This guide explains how to upgrade your Windows Subsystem for Linux (WSL) distribution from Version 1 (WSL 1) to Version 2 (WSL 2). WSL supports two versions: the original WSL 1 and the more advanced WSL 2. You can install multiple Linux distributions on your system and easily…
Read More
How to Downgrade from WSL Version 2 to WSL Version 1

August 2, 2022

In certain development or system administration scenarios, you may need to downgrade your Windows Subsystem for Linux (WSL) distribution from WSL version 2 (WSL 2) to version 1 (WSL 1). While WSL 2 brings many enhancements, such as a real Linux kernel and better performance, there are times…
Read More
How to Check Linux Version in Ubuntu

July 29, 2022

To check the Linux version running on an Ubuntu system, you can use the lsb_release -a or cat /etc/os-release commands. This is especially useful when accessing a host for the first time or verifying the installed Linux distribution and version. In this post, I’ll demo two ways to…
Read More
How to Open WSL Projects in Windows File Explorer

July 27, 2022

If you work with Windows Subsystem for Linux (WSL), you may need to open WSL files in Windows File Explorer for easier file management. This post gives some tips, providing two simple methods to achieve this. Best Practices for Managing WSL Project Files For best performance, always store…
Read More
Drop Table if Exists in SQL Server

July 26, 2022

The DROP TABLE command in SQL Server is used to remove a table from the database permanently. However, attempting to drop a non-existent table can result in execution errors. To prevent this, SQL Server 2016 introduced the DROP TABLE IF EXISTS command, which makes the process more efficient…
Read More
How to Change Your Default Distro in WSL

July 25, 2022

Changing the default Windows Subsystem for Linux (WSL) distribution is simple. This guide shows you how to list your installed distros and set a new default using just a couple of commands. 1. Listing Installed WSL Distributions Before setting a new default, check which distributions are installed on…
Read More

Categories

Tags