Question: My question is what are the command or codes for these steps? For this hands-on project, you will use the SQL Server named instance SQLSERVERHOA
My question is what are the command or codes for these steps?
For this hands-on project, you will use the SQL Server named instance SQLSERVERHOA and the HandsOnOne database and tables that you created in previous chapters. The objective of this activity is to practice generating keys and encrypting/decrypting data. Document each step by taking a screen Management Studio, open a new Query Editor window, after successfully executing each SQL query. In SQL Server Management Studio, open a new Query Editor window, which you will use for completing all steps in this activity. Create a SQL query to generate a new database master key and certificate for the HandsOnOne database. Construct a SQL query to generate a new symmetric key for encrypting data. The symmetric key should use the AES algorithm with a 256-bit key size, and it should be protected by the certificate that you created in Step 2. Construct SQL query to alter the Customer table and add a new column named CustomerNameEncrypted with data type varbinary (128). This column will be used to store the encrypted values of the CustomerName column. Using the symmetric key that you created in Step 2, write a SQL UPDATE query that encrypts the values in the CustomerName column and adds the encrypted values to the CustomerNameEncrypted column. Construct a SQL SELECT query to view the encrypted values of the CustomerNameEncrypted column in the Customer table. Construct a SELECT SQL query that uses the symmetric key to decrypt the values in the CustomerNameEncrypted column. Close SQL Server Management Studio
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
