Peter Whyte

Author: Peter Whyte

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…
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…
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…
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…
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…
Read More
How to Check WSL Distro Versions

July 20, 2022

This is a quick post on how to check your Windows Subsystem for Linux (WSL) distribution versions, with added info on what being on a different WSL version…
Read More
Git Log One Line

July 19, 2022

How to get a one-line git log, with the graph, aliases, dates and authors.
Read More
How To Install Windows Subsystem for Linux (WSL)

July 18, 2022

Want to run Linux directly on your Windows machine? Windows Subsystem for Linux (WSL) makes it easy! This guide provides a quick demo on how to get WSL enabled…
Read More
Why Use WHERE 1=2 in SQL

May 5, 2022

In a previous blog post, I explained why WHERE 1=1 is often used in SQL queries. This time, let’s discuss WHERE 1=2 — or any condition that results in a FALSE…
Read More

Start with a guide

Three guides collect the posts by the job you are doing rather than by date.

PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth having

Looking for SQL Server?

This site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.

sqldba.blogScripts, error library, wait types, SSMS