Encrypting Your Valuable Data With SQL Server 2005: Part 2



Other Practices

You can use Symmetric Keys to encrypt data for individual users; for example, when you have one table with two sets of user data for two different users. Since each user needs access only to their own set of data, each set of user data can be encrypted with a different Symmetric Key.

All the keys should be kept in a secure place. To put it simply, if you lose a key that was used to encrypt data, you risk losing that data.



Conclusion

Many methods are available for data encryption. You need only select the appropriate one.

I hope these articles have given you a sound understanding of SQL Server 2005 data encryption. Now practice what you learned and write your own scripts and code using these new functions. Then explore the possibilities of using SQL Server 2005 encryption in your projects to protect your valuable data.

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |