List android debug.keystore keys

On Windows:
keytool -list -v -keystore %USERPROFILE%\.android\debug.keystore

default password is "android"

Install Chocolatey (choco) on Windows

On administrator command line prompt run the following command:

@powershell -NoProfile -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))" && SET "PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin"


From PowerShell:

Set-ExecutionPolicy Bypass
iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))


To upgrade Chocholatey:
choco upgrade chocolatey

Excel convert YYYYWW to date

=DATE(LEFT(A1,4), 1, -2) - WEEKDAY(DATE(LEFT(A1,4), 1, 3)) + RIGHT(A1,2) * 7

Linux check disk free space command

fd -h

Converting SQL text columns from a single byte character codes to UTF8

use my_database;
-- preserve your old data in blob type
alter table my_tabe change my_column my_column blob;
-- set your default encoding to utf8
alter table my_table convert to character set utf8;
-- tell sql server your old code page ( i.e.: cp1256 )
alter table my_table change my_column my_column text charset {{code page}};

Convert Non-UTF8 tables to UTF8 in sql database

-- convert old text columns to blob,
ALTER TABLE my_table CHANGE my_column_name my_column_name BLOB;
-- then update table character set
ALTER ignore TABLE my_table CONVERT TO CHARACTER SET utf8;
-- then convert the text columns back to text type

ALTER TABLE my_table CHANGE my_column_name my_column_name TEXT;

-- If your old scripts break, try explicitly setting the names to UTF8 before making sql queries
SET NAMES utf8;
SELECT my_column_name FROM my_table limit 10;