TECH TO THE POINT

Error: Gpg4win - Kleopatra - Error Set up at least one ceterificate server FIX: This document shows details about PGP Certificate servers and how to set up one.    http://gpg4win.org/doc/en/gpg4win-compendium_22.html At the fist time you open the Kleopatra - Settings first row in the below window may be empty. Just 'CLICK THE NEW BUTTON' - it will automatically fill up this default certificate server  ( hkp://keys.gnupg.net   ) for you. The above document doesn't address this correctly. Great reference: http://www.gpg4win.org/ http://dev.mysql.com/doc/refman/5.6/en/checking-gpg-signature-windows.html

Issue:  HASHBYTES ( algm, str) function generated hash code differ from regular/ other MD5 programs by the data type.  Data: 'mypassword1'  If you pass a variable as below as mentioned in the link in 'Ref' below,  DECLARE @HashThis nvarchar(4000); SELECT @HashThis = CONVERT(nvarchar(4000),'mypassword1'); SELECT HASHBYTES('MD5', @HashThis ); GO ---- This will generate a Hashed code :  0xBAE02911AA20CACE81224DCA98610B05 If you try the same in different MD5 generator tool like this website :  Type 'mypassword1' http://www.miraclesalad.com/webtools/md5.php ---- the generated Hashed code will be,  0d28e4080dc8f64fc9603639bb7aa1b9 Hashcodea are different. Cause: SQL Server differs the algorithm by the data type - here it is not just string , it is nvarchar / varchar - SQL Server adds up spaces or truncate them as to the size of the data. DECLARE @HashThis nvarchar(4000); SELECT @HashThis = CONVERT(nvarchar(4000),'mypassword...