Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Blogs, Encryption Rss

   Items 1 to 9 of 9   
 

Symmetric Keys

One of the encryption options in SQL Server is symmetric key encryption. This is the type of encryption most people...  Read more...
By Steve Jones 2013/12/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,549 reads

Does TDE really work on MDF files?

Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data: -- create a...  Read more...
By Steve Jones 2013/04/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,796 reads

Enable Transparent Data Encryption

This is one of the things in my Encryption Primer presentation that I don’t demo. It’s really easy to do,...  Read more...
By Steve Jones 2012/08/30 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,762 reads

Database Corruption, Transparent Data Encryption, and Trace Flag 5004

This one comes straight from the email bag.  A friend recently had a problem, they were placing TDE on a...  Read more...
By 2012/08/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,861 reads

Decryption and CASTing

In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...  Read more...
By Steve Jones 2012/07/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,646 reads

Does Encryption Affect Seeing Statements in Deadlock Graphs?

Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure: CREATE PROCEDURE DL2e ...  Read more...
By 2012/07/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,292 reads

Backing up a Certificate

If you create your own certificate in SQL Server, you need to make sure that you back it up immediately....  Read more...
By 2012/03/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,871 reads

SQL Server Encryption - Hashing Collisions

A hash is a computation that transforms one set of data into another (hopefully smaller) set of data. So a hash on your 2,000 character blog post should generate a smaller, 10-20 byte value. In doing that, obviously there are many more possible 2,000...  Read more...
By Steve Jones 2009/06/09 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,987 reads

Asymmetric Keys in SQL Server

I've been tech editing an encryption book for SQL Server. It's long overdue, and I think it will be a nice addition to any DBA's library. It also addresses a complicated subject that Books Online has inadequately covered. In fact, they've...  Read more...
By Steve Jones 2009/05/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,639 reads
   Items 1 to 9 of 9   
 
Tags
transparent data encryption (tde) (3)    
backup / recovery (1)    
certificates (1)    
deadlock graph trace (1)    
hashing (1)    
symmetric keys (1)