Abstract
SQL Server 2012 supports built-in column- and database-level encryption functionality directly through T-SQL. Column-level encryption allows you to encrypt the data in your database at the column level. Back in the days of SQL Server 2000 (and before), you had to turn to third-party tools or write your own extended stored procedures (XPs) to encrypt sensitive data. Even with these tools in place, subpar implementation of various aspects of the system, such as encryption key management, could leave many systems in a vulnerable state.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Jay Natarajan, Rudi Bruchez, Scott Shaw, and Michael Coles
About this chapter
Cite this chapter
Natarajan, J., Bruchez, R., Shaw, S., Coles, M. (2012). Encryption. In: Pro T-SQL 2012 Programmer’s Guide. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4597-1_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4597-1_7
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4596-4
Online ISBN: 978-1-4302-4597-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books