Skip to content

Instantly share code, notes, and snippets.

Andrew Kramarev akramarev

Block or report user

Report or block akramarev

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
akramarev / sql-progress.sql
Last active Jul 21, 2019
[Print out long running mssql backup/restore queries]
View sql-progress.sql
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
akramarev / NunitShortPathFinderApp.cs
Created Jul 11, 2019
[Nunit] Nunit Short Path Finder App. Works in linqpad also.
View NunitShortPathFinderApp.cs
class Program
static void Main(string[] args)
XDocument xDocument;
using (XmlReader xr = XmlReader.Create(@"c:\Users\akramarev\Downloads\TestResultSet.xml"))
xDocument = XDocument.Load(xr);
akramarev / get_permissions.sql
Created Jun 22, 2019
[get all mssql permissions grants]
View get_permissions.sql
dp.state_desc + ' ' +
dp.permission_name collate latin1_general_cs_as +
' ON ' + '[' + + ']' + '.' + '[' + + ']' +
' TO ' + '[' + + ']'
FROM sys.database_permissions AS dp
INNER JOIN sys.objects AS o ON dp.major_id=o.object_id
INNER JOIN sys.schemas AS s ON o.schema_id = s.schema_id
akramarev /
Created Mar 24, 2019
[quickly create new dotnet core test project and run tests] @leetcode
dotnet new nunit
dotnet add package FluentAssertions
dotnet test
akramarev / _.ps1
Created Jan 28, 2019
[how to build Go program for linux on windows]
View _.ps1
$env:GOOS = "linux"
akramarev /
Created Jan 28, 2019
[pk12 into pem]
# 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 /
Last active Jan 26, 2019
[git for wsl] Makes git faster on WSL #wsl #osreinstall
# WSL 'git' wrapper, save as /usr/local/bin/git and chmod a+x
REALPATH=`readlink -f ${PWD}`
if [ "${REALPATH:0:5}" == "/mnt/" ]; then
git.exe "$@"
/usr/bin/git "$@"
akramarev /
Last active Jan 22, 2019
[colortool] Change theme for windows consoles

Download tool from here:, 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 / Export-Chocolatey.ps1
Created Jan 19, 2019 — forked from alimbada/Export-Chocolatey.ps1
Export installed Chocolatey packages as packages.config - thanks to Matty666
View Export-Chocolatey.ps1
#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>"
View git-local-cleanup
git remote prune origin
git branch -vv | grep 'origin/.*: gone]' | awk '{print $1}' | xargs git branch -d
You can’t perform that action at this time.