Encryption

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Vyas DCS » Encryption

19 posts, Page 1 of 2

1 2 »»

Encryption

Rate Topic

Display Mode

Topic Options

Author

Message

vyas

Posted Monday, March 22, 2010 8:44 PM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:02 AM
Points: 3,131, Visits: 1,056

Comments posted to this topic are about the item Encryption

Post #887823

Ric Sierra

Posted Monday, March 22, 2010 10:11 PM

Ten Centuries

Group: General Forum Members
Last Login: Friday, June 14, 2013 6:25 PM
Points: 1,422, Visits: 254

Check out this links...
http://msmvps.com/blogs/gladchenko/archive/2005/04/06/41083.aspx
http://www.sqlservercentral.com/articles/Security/saveyourpassword/1420/

this undocumented function is available since SQLServer 7

so... what you think?

Post #887833

Sree Arjun Div

Posted Tuesday, March 23, 2010 1:15 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:44 AM
Points: 2,173, Visits: 1,350

In SQL Server 2005, column-level (sometimes called cell-level) encryption became available. Now, encryption could occur within the database, but it was not easy to use, offered poor performance, and it required a re-architecture of the application, along with changes to the database schema. Even with these downsides, column-level encryption offered some advantages: such as granular security; data is encrypted in memory and disk; and explicit key management, which allows different users to protect their own data using their own keys, even preventing the DBA from seeing a user’s data. Even so, the disadvantages were so great that only the most sensitive columns of a table were generally encrypted, which meant that much of the data in a database was still left unencrypted

Post #887875

Carlo Romagnano

Posted Tuesday, March 23, 2010 1:53 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 1,996, Visits: 1,864

Ric Sierra (3/22/2010)

Thank you! I love undocumented. I learned something new! Smile

Post #887879

vk-kirov

Posted Tuesday, March 23, 2010 1:57 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 8:50 PM
Points: 3,208, Visits: 4,178

Ric Sierra (3/22/2010)

this undocumented function is available since SQLServer 7

PWDENCRYPT is a hash function, which means it's a one-way function. Once hashed, data cannot be restored. With cell-level encryption, data can be both encrypted and decrypted.

Post #887884

vk-kirov

Posted Tuesday, March 23, 2010 2:09 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 8:50 PM
Points: 3,208, Visits: 4,178

Carlo Romagnano (3/23/2010)

Thank you! I love undocumented.

I'm afraid you'll be disappointed in this function since it became documented (and obsolete at the same time) in SQL Server 2008 Smile

http://msdn.microsoft.com/en-us/library/dd822791.aspx

Post #887890

Posted Tuesday, March 23, 2010 3:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 11, 2013 12:58 AM
Points: 174, Visits: 555

If SQL 2008 was part of the choices, my guess would have been wrong as I decided to choose the newest of the three.

Post #887916

Peter Trast

Posted Tuesday, March 23, 2010 7:33 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 15, 2013 10:35 AM
Points: 594, Visits: 654

Open Minded (3/23/2010)

If SQL 2008 was part of the choices, my guess would have been wrong as I decided to choose the newest of the three.

Yeah, same...

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems

Post #888114

KWymore

Posted Tuesday, March 23, 2010 7:36 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 11:48 AM
Points: 2,602, Visits: 1,553

Not to be too picky but if cell level encryption was available since SQLServer 7 wouldn't SQLServer 7 have been the correct answer? Even if it was undocumented and poorly performing, it was still technically available, correct?

Post #888120

Tom Garth

Posted Tuesday, March 23, 2010 12:30 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 04, 2011 7:20 AM
Points: 977, Visits: 1,499

Me too.

Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

Post #888430

« Prev Topic | Next Topic »

19 posts, Page 1 of 2

1 2 »»

Permissions