Tag: asymmetric key

• You’ve been Hacked! [T-SQL Tuesday #63 – Security]

  

  2015-02-10 - Audit, Cryptography, General, Security, T-SQL Tuesday

  One Billion – The number of accounts affected by security breaches during the last ten years. Is the data of your customers safe with you?

  [more…]

• Common Database Vulnerabilities: Flawed Key Management

  

  2014-09-23 - Common Database Vulnerabilities, Cryptography, General, HIPAA, PCI DSS, Security, Series

  Encrypting important data is not enough. You also need to handle the encryption keys correctly. Read on to see what flawed key management can result in.

  [more…]

• OPEN SYMMETRIC KEY – Avoid the NULL Ciphertext Trap

  

  2014-07-11 - Cryptography, General, Security, Security Pitfalls, T-SQL Statements

  Don’t get caught in this nasty trap that will cause all your encrypted data to be wiped out. Discover how to use the OPEN SYMMETRIC KEY statement correctly to protect yourself (and your data) from this ugly surprise.

  [more…]

• The Missing BACKUP ASYMMETRIC KEY statement

  

  2014-06-02 - Backup, General, Security

  Is the BACKUP ASYMMETRIC KEY statement really missing from the T-SQL language? Read on to discover the truth and see if there are any viable alternatives.

  [more…]

• Creating an Asymmetric Key using a Strong Name File

  

  2014-05-30 - Cryptography, General, Security

  .NET Strong name files are built to hold a single asymmetric key pair. Read on to discover how to generate SQL Server asymmetric keys form strong name files.

  [more…]