One Billion – The number of accounts affected by security breaches during the last ten years. Is the data of your customers safe with you?
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.
What do you need to do to decrypt data that was encrypted with ENCRYPTBYPASSPHRASE? Read on to see the DECRYPTBYPASSPHRASE function in action.
If you are searching for a quick and dirty way to encrypt data in SQL Server, the ENCRYPTBYPASSPHRASE function might be just what you are looking for.
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.