Tag: Hash Value

• HASHBYTES: How to Calculate a Cryptographic Hash in T-SQL

  

  2014-07-07 - Cryptography, General, Security

  The HASHBYTES function provides a simple way to calculate cryptographic hash values in T-SQL. Read on to learn how to use this function and discover its two limitations.

  [more…]

• Hash Algorithms – How does SQL Server store Passwords?

  

  2014-06-30 - General, Passwords, Security, SQL Server Internals

  How does SQL Server store its own passwords? Discover which hashing algorithm is used and how you can calculate your own password hash value in T-SQL.

  [more…]

• Auditing SQL Server Password Strength using PWDCOMPARE

  

  2014-06-27 - DMVs & CVs, General, Passwords, Security, Security

  SQL Server stores passwords as salted hash values, preventing us from directly checking or enforcing their strength. However, using PWDCOMPARE we can try to crack them to identify weak ones.

  [more…]

• Cryptographic Hash Functions

  

  2014-03-30 - Cryptographic Terminology, Cryptography, General, Security, Series

  Hash functions calculate a fixed length binary digest of a document. Read on to see what additional requirements turn an ordinary hash function into a cryptographic hash function and what use cases require the use of cryptographic hash functions.

  [more…]