Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Encryption Expand / Collapse
Author
Message
Posted Monday, March 22, 2010 8:44 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 7:16 AM
Points: 3,931, Visits: 1,102
Comments posted to this topic are about the item Encryption


Post #887823
Posted Monday, March 22, 2010 10:11 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, August 31, 2014 6:28 AM
Points: 1,426, Visits: 342
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
Posted Tuesday, March 23, 2010 1:15 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 8, 2014 6:07 AM
Points: 2,301, Visits: 1,436
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
Posted Tuesday, March 23, 2010 1:53 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:20 AM
Points: 2,622, Visits: 2,472
Ric Sierra (3/22/2010)
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?

Thank you! I love undocumented. I learned something new!
Post #887879
Posted Tuesday, March 23, 2010 1:57 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, May 9, 2014 12:47 AM
Points: 3,448, Visits: 4,407
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
Posted Tuesday, March 23, 2010 2:09 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, May 9, 2014 12:47 AM
Points: 3,448, Visits: 4,407
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 http://msdn.microsoft.com/en-us/library/dd822791.aspx
Post #887890
Posted Tuesday, March 23, 2010 3:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 18, 2014 4:04 AM
Points: 176, Visits: 567
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
Posted Tuesday, March 23, 2010 7:33 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
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
Posted Tuesday, March 23, 2010 7:36 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:17 PM
Points: 3,417, Visits: 2,036
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
Posted Tuesday, March 23, 2010 12:30 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 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 »

Add to briefcase 12»»

Permissions Expand / Collapse