Skip to content

Instantly share code, notes, and snippets.

View akramarev's full-sized avatar

Andrew Kramarev akramarev

11 followers · 8 following
View GitHub Profile
@akramarev
akramarev / install-docker.sh
Created August 30, 2014 16:32
get latest docker
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
akramarev / new_gist_file.ps1
Last active January 29, 2016 11:01
Windows disk space, allocation, directories size
Get-ChildItem | Where-Object { $_.PSIsContainer } | ForEach-Object { $_.Name + ": " + "{0:N2}" -f ((Get-ChildItem $_ -Recurse | Measure-Object Length -Sum -ErrorAction SilentlyContinue).Sum / 1MB) + " MB" }
@akramarev
akramarev / update-udp.sql
Created June 24, 2017 18:29
Update UDT MSSQL User Defined Types
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
akramarev / git-on-windows.bat
Created December 14, 2017 19:48
git config --global core.preloadindex true
git config --global core.fscache true
git config --global gc.auto 256
@akramarev
akramarev / kill-sessions.sql
Created March 16, 2018 21:25
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
akramarev / git-local-cleanup
Last active October 31, 2023 18:15
[Git Tip: Deleting Old Local Branches] http://erikaybar.name/git-deleting-old-local-branches/
git remote prune origin
git branch -vv | grep 'origin/.*: gone]' | awk '{print $1}' | xargs git branch -D
@akramarev
akramarev / sql-progress.sql
Last active July 21, 2019 07:41
[Print out long running mssql backup/restore queries]
SELECT session_id as SPID, command, a.text AS Query, start_time, percent_complete, dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time
FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a
WHERE r.command in ('BACKUP DATABASE','BACKUP LOG','RESTORE DATABASE')
@akramarev
akramarev / git.sh
Last active January 26, 2019 22:59
[git for wsl] Makes git faster on WSL #wsl #osreinstall
#!/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
akramarev / Export-Chocolatey.ps1
Created January 19, 2019 07:17 — forked from alimbada/Export-Chocolatey.ps1
Export installed Chocolatey packages as packages.config - thanks to Matty666
#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
akramarev / readme.md
Last active January 22, 2019 04:04
[colortool] Change theme for windows consoles

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