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.
Temporary symmetric keys are a great idea. However, SQL Server’s current implementation falls apart based on a requirement that makes them all but usable.
If you think temporary symmetric keys and temporary tables have the same scope, you will be in for a surprise. Read on to discover the truth.
Temporary symmetric keys in SQL Server behave similar to temp tables. In particular, they are stored in tempdb and automatically go away at the end of the session. Make sure however that you do not get caught creating a non-recreatable temporary symmetric key…
SQL Server provides only one way to re-create a symmetric key multiple times. Read on to find out about the necessary extension to the CREATE SYMMETRIC KEY statement.