akramarev

wget -qO- https://get.docker.io/gpg | sudo apt-key add -
sudo sh -c "echo deb http://get.docker.io/ubuntu docker main > /etc/apt/sources.list.d/docker.list"
sudo apt-get update
sudo apt-get install lxc-docker

akramarev

Get-ChildItem | Where-Object { $_.PSIsContainer } | ForEach-Object { $_.Name + ": " + "{0:N2}" -f ((Get-ChildItem $_ -Recurse | Measure-Object Length -Sum -ErrorAction SilentlyContinue).Sum / 1MB) + " MB" }

akramarev

DECLARE @Name NVARCHAR(776) = NULL;

EXEC sys.sp_rename 'dbo.MyUDT', 'zMyUDT';
GO

CREATE TYPE [dbo].[MyUDT] AS TABLE
(
[HierarchyId] [int] NOT NULL
)
GO

akramarev

git config --global core.preloadindex true
git config --global core.fscache true
git config --global gc.auto 256

akramarev

DECLARE @kill varchar(8000) = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM sys.dm_exec_sessions
WHERE 
	database_id  = db_id('DBUser')
	AND login_name IN ('DBTest', 'DBServices')

EXEC(@kill);

akramarev

#Put this in Export-Chocolatey.ps1 file and run it:
#Export-Chocolatey.ps1 > packages.config
#You can install the packages using
#choco install packages.config -y

Write-Output "<?xml version=`"1.0`" encoding=`"utf-8`"?>"
Write-Output "<packages>"
choco list -lo -r -y | % { "   <package id=`"$($_.SubString(0, $_.IndexOf("|")))`" version=`"$($_.SubString($_.IndexOf("|") + 1))`" />" }
Write-Output "</packages>"

akramarev

Download tool from here: https://github.com/Microsoft/console/releases, then apply to every console: ps1, cmd, ubuntu

• ColorTool.exe -b OneHalfDark
• Right click on the window title to access the ‘Properties’ dialogue box
• Once the properties dialogue box opens press OK (which saves the color change)

ColorTool.exe -b OneHalfDark

akramarev

#!/bin/bash
# WSL 'git' wrapper, save as /usr/local/bin/git and chmod a+x
# https://github.com/Microsoft/WSL/issues/981#issuecomment-363638656

REALPATH=`readlink -f ${PWD}`

if [  "${REALPATH:0:5}" == "/mnt/" ]; then
  git.exe "$@"
else
  /usr/bin/git "$@"

akramarev

# https://stackoverflow.com/questions/15144046/converting-pkcs12-certificate-into-pem-using-openssl
# After that you have:
# - certificate in newfile.crt.pem
# - private key in newfile.key.pem

openssl pkcs12 -in path.p12 -out newfile.crt.pem -clcerts -nokeys
openssl pkcs12 -in path.p12 -out newfile.key.pem -nocerts -nodes

akramarev

# https://stackoverflow.com/questions/20829155/how-to-cross-compile-from-windows-to-linux
$env:GOOS = "linux"