hoangitk hoangitk

Shrink your WSL2 Virtual Disks and Docker Images and Reclaim Disk Space

Credit: https://www.hanselman.com/blog/shrink-your-wsl2-virtual-disks-and-docker-images-and-reclaim-disk-space

Docker Desktop for Windows uses WSL to manage all your images and container files and keeps them in a private virtual hard drive (VHDX) called ext4.vhdx.

It's usually in C:\Users\YOURNAME\AppData\Local\Docker\wsl\data and you can often reclaim some of the space if you've cleaned up (pruned your images, etc) with Optimize-Vhd under an administrator PowerShell shell/prompt.

You'll need to stop Docker Desktop by right clicking on its tray icon and choosing Quit Docker Desktop. Once it's stopped, you'll want to stop all running WSL2 instances with wsl --shutdown

Mine was 47gigs as I use Docker A LOT so when I optimize it from admin PowerShell from the wsl\data folder

curl in Powershell

https://www.educative.io/edpresso/curl-in-powershell

Make a web request to the educative website:

 Invoke-WebRequest -URI https://www.educative.io/

How to download file without browser

BITS

bitsadmin /transfer myDownloadJob /download /priority normal https://downloadsrv/10mb.zip c:\\10mb.zip

Powershell

#SQL Troubleshoot Connection

Errors

pre-login-handshake: https://docs.microsoft.com/en-us/archive/blogs/dataaccesstechnologies/an-error-occurred-during-the-pre-login-handshake-dbnetlibconnectionopen-secdoclienthandshake-ssl-security-error-when-connecting-to-sql-server

SSH Command

Connect to server

> ssh <user>@<server>

Send remote command

> ssh <user>@<server> <command>

Favorites Folder

NuGet Cache

Stores downloaded NuGet packages (.nupkg). (From http://lastexitcode.com/projects/NuGet/FileLocations/ )
- Mac • ~/.local/share/NuGet/Cache • ~/.nuget/packages
- Windows • %LocalAppData%\NuGet\Cache • %UserProfile%.nuget\packages

Fresh Installation

Prompt

Command Line

> setx PROMT $P$_$G

Riot v3 Refs

Links

Icons by Unicode

Refresh
```
⭯ ⭮ ↺ ↻ ⟲ ⟳ 🔃🔄
```

	/*
	credit: https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases
	*/

	DECLARE @name VARCHAR(50) -- database name
	DECLARE @path VARCHAR(256) -- path for backup files
	DECLARE @fileName VARCHAR(256) -- filename for backup
	DECLARE @fileDate VARCHAR(20) -- used for file name

	-- specify database backup directory