hoangitk hoangitk

Git Practice

Ad-hoc merge specific file from branch

Credit: https://stackoverflow.com/questions/18115411/how-to-merge-specific-files-from-git-branches When content is in file.py from branch2 that is no longer applies to branch1, it requires picking some changes and leaving others. For full control do an interactive merge using the --patch switch:

$ git checkout --patch branch2 file.py

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

Apps

# Universal Runner:
winget install Esubaalew.Run

Prompt

Command Line

	public static List<T> Query<T>(this DataContext db, string sql, object param = null, int? commandTimeout = null, IDbTransaction transaction = null, [CallerFilePath]string fromFile = null, [CallerLineNumber]int onLine = 0, string comment = null)
	{
	using (db.Connection.EnsureOpen())
	{
	try
	{
	return db.Connection.Query<T>(MarkSqlString(sql, fromFile, onLine, comment), param, transaction ?? db.Transaction, true, commandTimeout).AsDapperList();
	}
	catch (SqlException ex) when (ex.Is(SqlErrorCode.DatabaseReadOnly_3906))
	{

	/*
	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