Misc Algorithms and SQL scripts

Recover MySQL root Password

by Vivek Gite ·  You can recover MySQL database server password with following five easy steps. Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for ...

Encryption Algorithms

article from http://www.mycrypto.net/encryption/crypto_algorithms.html Encryption Algorithms Different encryption algorithms use proprietory methods of generating these keys and are therefore useful for different applications. Here are some nitty gritty details abo...

SQL Generate data dictionary

with PrimaryKey as ( select so.id, sc.colid, sc.name  from syscolumns sc inner join  sysobjects so on so.id = sc.id inner join  sysindexkeys si on so.id = si.id and sc.colid = si.colid where si.indid = 1 ) select  a.name 'Table Name', b.name 'Column Name'...

Excel Unprotect Sheet

Forgot Excel Password? Goto Review tab on excel spreadsheet, check if protected Press ALT +  F11 or click on View Code in Developers Tabs Copy and paste code below into VBA editor window and press F5 to execute Sub PasswordBreaker()     'Breaks worksheet password prot...

Code Signing

http://stackoverflow.com/questions/84847/how-do-i-create-a-self-signed-certificate-for-code-signing-on-windows http://www.jrsoftware.org/ishelp/index.php?topic=setup_signtool Full Microsoft Documentation signtool: http://msdn.microsoft.com/en-us/library/8s9b9yaz.aspx makecert:&nbs...

True Crypt Archive

https://www.grc.com/misc/truecrypt/truecrypt.htm...

SVN Branching

svn copy svn+ssh://host.example.com/repos/project/trunk \ svn+ssh://host.example.com/repos/project/branches/NAME_OF_BRANCH \ -m "Creating a branch of project"...

Crystal Reports Archive

http://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports+v.+9.1+to+SAP+Crystal+Reports,+developer+version+for+Microsoft+Visual+Studio+Runtime+Distribution++and+Supported+Operating+Systems  ...

GIT cheats

# initial git install git config --global user.email "email@email.com" git config --global user.name "my name" git config --global --list git core.editor vim git help.autocorrect 1 git init # add current folder to git repo git add . # status / changes to be committed...