June 11, 2013 at 2:16 pm
Hi Friends,
I want to know how we can encrypt the specific Objects(table) in database!!
Can we do it on field level in Object(table)?
what is overhead actully mean in encyption?
thanks.
June 11, 2013 at 2:43 pm
Hi friends,
I found this wonderful article with example on
from other posts..
But I am still wondering about what is "Overhead" means in encyption?
Please help.
thanks.
June 11, 2013 at 2:48 pm
Learner44 (6/11/2013)
Hi friends,I found this wonderful article with example on
from other posts..
But I am still wondering about what is "Overhead" means in encyption?
Please help.
thanks.
"Overhead" in encryption is referring to the inherent resource usage for both encrypting and decrypting information. There is a certain amount of delay required for either process. This is unavoidable and any process that is using encryption will be somewhat slower than a non-encrypted version of the same process. This does not mean you should not incorporate encryption when appropriate but you should be sure that the data you are encrypting should be encrypted.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 11, 2013 at 2:53 pm
Learner44 (6/11/2013)
what is overhead actully mean in encyption?
It means that each time you encrypt or decrypt data, processing cycles are used on it - processing cycles that would not be used if encryption wasn't part of the equation. That is overhead.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 11, 2013 at 3:30 pm
I am having following issue.
I created encryption certificate using master 3-4 day before.
I want drop that master key now..
when I tried following thing it gives me error.
1> DROP MASTER KEY
Msg 15580, Level 16, State 1, Line 1
Cannot drop master key because certificate 'MyServerCert' is encrypted by it.
2> DROP CERTIFICATE MyServerCert
Msg 3716, Level 16, State 15, Line 1
The certificate 'MyServerCert' cannot be dropped because it is bound to one or more database encryption key.
3> USE master;
ALTER MASTER KEY
DROP ENCRYPTION BY SERVICE MASTER KEY
GO
command success fully run.
4> USE master;
DROP MASTER KEY;
Msg 15580, Level 16, State 1, Line 3
Cannot drop master key because certificate 'MyServerCert' is encrypted by it.
I want to drop that master key and want to create again..because my file where I saved / backup is missing.
I want to start the whole process again and want to give new master key.
thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply