• subscribe
July 19, 2007 12:00 AM

A Brief Background on Encoding and Encryption

SQL Server Pro
InstantDoc ID #95729

A vast number of encoding and encryption methods are available for obfuscating and protecting data, respectively. Common examples include the turbo or convolution codes that are often used to encode digital communication signals, or RSA, Blowfish, and other hashing techniques. The complexity of various decoding and decryption algorithms is often measured by the amount of memory required to crack the stream of raw data (sometimes referred to as buffer size). With SQL Server, trial-and-error experiments have shown that WITH ENCRYPTION encodes (but doesn't actually encrypt) the text of database objects. Moreover, the buffer size equals the length of one unicode character (i.e., 2 bytes). In other words, decoding objects that were created WITH ENCRYPTION can be relatively straightforward.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...