Tag: security

• How to Create a Database Master Key

  

  2014-04-27 - Cryptography, Encryption Hierarchy, General, Security, Series

  Discover how to create and protect the Database Master Key that builds the base of a database encryption hierarchy and in turn can protect certificates and asymmetric keys in its database.

  [more…]

• How to Create a Service Master Key in SQL Server

  

  2014-04-25 - Cryptography, Encryption Hierarchy, General, Security, Series

  Discover how the service master key is created, what it protects and how it is protected itself, and learn about the two important security implications that arise from the protection mechanism used.

  [more…]

• How to Pick a Good Password

  

  2014-04-21 - General, Security

  Do you know why you care about picking a good password and why reusing a password is a bad idea, even if you think your life is boring to a would-be hacker. Read on to discover how hackers get a hold of long lists of usernames and passwords and that a hack on a random page you might have used once can be a real threat to your online life.

  [more…]

• The SQL Server Encryption Hierarchy

  

  2014-04-20 - Cryptography, Encryption Hierarchy, General, Security, Series

  Discover how in SQL Server the different encryption keys can build a complex encryption hierarchy in which one key protects the next.

  [more…]

• Auto Fix Orphaned Users

  

  2014-04-18 - General, Security

  To auto fix orphaned users safely is a surprisingly complex task. But, as demonstrated in this article, it is possible if you follow a handful of rules.

  [more…]