SQLServerCentral.com Content tagged Blogs, Encryption

Does TDE really work on MDF files?

Fri, 26 Apr 2013 06:00:00 UT

Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data: -- create a...

Enable Transparent Data Encryption

Thu, 30 Aug 2012 06:00:00 UT

This is one of the things in my Encryption Primer presentation that I don’t demo. It’s really easy to do,...

Database Corruption, Transparent Data Encryption, and Trace Flag 5004

Fri, 17 Aug 2012 06:00:00 UT

This one comes straight from the email bag. A friend recently had a problem, they were placing TDE on a...

Decryption and CASTing

Wed, 11 Jul 2012 06:00:00 UT

In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...

Does Encryption Affect Seeing Statements in Deadlock Graphs?

Tue, 03 Jul 2012 06:00:00 UT

Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure: CREATE PROCEDURE DL2e ...

Backing up a Certificate

Wed, 07 Mar 2012 07:00:00 UT

If you create your own certificate in SQL Server, you need to make sure that you back it up immediately....

SQL Server Encryption - Hashing Collisions

Tue, 09 Jun 2009 06:00:00 UT

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...

Asymmetric Keys in SQL Server

Fri, 08 May 2009 06:00:00 UT

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...