question

I checked the link you provided, and someone there gave a link to the TechNet article explaining how to encrypt network protocols used by SQL Server. I found an updated article of the same topic [here][1], and that one includes some additional information. Alternatively, if you do not have permission to (or can/should not for any reason) change SQL Server configuration properties, there is a TSQL method of encrypting specific pieces of data using the function [EncryptByKey][2] (and DecryptByKey). Here's a simple example from MSDN assuming you create a symmertic key if you do not already have one): USE AdventureWorks2012; GO -- Create a column in which to store the encrypted data. ALTER TABLE HumanResources.Employee ADD EncryptedNationalIDNumber varbinary(128); GO -- Open the symmetric key with which to encrypt the data. OPEN SYMMETRIC KEY SSN_Key_01 DECRYPTION BY CERTIFICATE HumanResources037; -- Encrypt the value in column NationalIDNumber with symmetric key -- SSN_Key_01. Save the result in column EncryptedNationalIDNumber. UPDATE HumanResources.Employee SET EncryptedNationalIDNumber = EncryptByKey(Key_GUID('SSN_Key_01'), NationalIDNumber); GO [1]: http://msdn.microsoft.com/en-us/library/ms191192.aspx [2]: http://msdn.microsoft.com/en-us/library/ms174361.aspx