jrdmb

Other links to creating SHA-512 hashes in various Windows apps:

[VBA SHA-512 using Windows API calls with advapi32.dll, 32 or 64 bit] (https://gist.githubusercontent.com/jermity/b12e26bc1adb38840099/raw/vba_advapi32_64-bit.vb)
[ColdFusion] (https://gist.github.com/search?l=cfm&q=sha-512 )
[ColdFusion SHA-512 Search] (https://gist.github.com/search?q=sha-512+coldfusion)
[Javascript] (https://gist.github.com/search?l=javascript&q=sha-512)
[Sql Server] (https://gist.github.com/jermity/ed98716aab76f73f9276/raw/tsql_string_encryption.sql)

The code below is adapted from: http://stackoverflow.com/questions/11394811/compute-sha512-on-vba-excel-2003

64-bit MS Access VBA code to calculate an SHA-512 or SHA-256 hash in VBA.  This requires a VBA reference to the .Net Framework 4.0 mscorlib.dll.  The hashed strings are calculated using calls to encryption methods built into mscorlib.dll.  The calculated hash strings are the same values as those calculated with jsSHA, a Javascript SHA implementation (see htt

	To list remote Git branches (from: http://rakhesh.com/coding/list-remote-branches/):
	git ls-remote
	git remote show origin

	Create and delete local and remote Git branches
	http://rakhesh.com/coding/creating-and-delete-remote-git-branches/

	Move the .git folder out of the working tree
	http://rakhesh.com/coding/how-to-move-separate-the-git-folder-out-of-your-working-tree/

	SELECT * FROM INFORMATION_SCHEMA.ROUTINES
	WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo'
	and SPECIFIC_NAME like 'usp%'

	select TABLE_NAME from INFORMATION_SCHEMA.TABLES

	#tsql

	'also see: https://gist.github.com/anonymous/573a875dac68a4af560d

	Option Explicit

	Dim intValid
	Dim objMD5, objSHA256
	Dim strAlgorithm, strHash, strString

	intValid = 0

	#Here is a simple script to hash a string using your chosen cryptography algorithm.
	#Usage Examples:
	#Get-StringHash "My String to hash" "MD5"
	#Get-StringHash "My String to hash" "RIPEMD160"
	#Get-StringHash "My String to hash" "SHA1"
	#Get-StringHash "My String to hash" "SHA256"
	#Get-StringHash "My String to hash" "SHA384"
	#Get-StringHash "My String to hash" "SHA512"

	#http://jongurgul.com/blog/#Get-StringHash-get-filehash/

	-- Database Role Members
	SELECT Users.name AS UserName, Roles.name AS RoleName,
	'EXEC sp_droprolemember '+QUOTENAME(Roles.name,'''')+','+QUOTENAME(Users.name,'''')+';' AS Drop_Script,
	'EXEC sp_addrolemember '+QUOTENAME(Roles.name,'''')+','+QUOTENAME(Users.name,'''')+';' AS Add_Script
	FROM sys.database_role_members RoleMembers
	JOIN sys.database_principals Users
	ON RoleMembers.member_principal_id = Users.principal_id
	JOIN sys.database_principals Roles
	ON RoleMembers.role_principal_id = Roles.principal_id
	--WHERE Users.name LIKE '%MyUserName%'

	--All relevant db objects and permissions
	;With CTE As
	(
	select o.name, o.type, o.type_desc, p.permission_name, p.state_desc, p.state, u.name as 'users'
	from sys.objects o
	left outer join sys.database_permissions p On o.object_id = p.major_id
	left outer JOIN sys.sysusers u ON p.grantee_principal_id = u.uid
	where o.type Not In ('D', 'F', 'IT', 'PK', 'S', 'SQ', 'UQ')
	)
	select distinct name, type, type_desc, permission_name, state_desc, state,