Call now: (800) 766-1884  


 SQL Server Tips
 SQL Server Training

 SQL Server Consulting
 SQL Server Support
 SQL Server Remote DBA

 SQL Server Scripts
 Scripts Menu




  SQL Server Tips by Gama and Naughter


In this chapter we have developed a number of XP’s housed in one DLL called XP_CRYPTOAPI, which provides a comprehensive collection of cryptography primitives using the Windows Crypto libraries. These include the key areas of hashing, message authentication codes, signatures and symmetric and asymmetric encryption / decryption. An example usage for this DLL would be where data is encrypted and decrypted on the fly as it is stored or received from SQL Server. This could be implemented quite easily using XP_CRYPTOAPI in combination with a trigger using “CREATE TRIGGER… INSTEAD OF INSERT” to perform the automatic encryption. A User Defined Function (UDF) and a select statement in a stored procedure can be used to decrypt the data. The XP’s developed in this chapter can also be quite easily extended to support additional functionality, such as to allow operation to take place on other types of data as opposed to simple parameters to each XP, or allow operation on multiple input parameters. Also additional functions could be exposed to work on files rather than parameters or to specify ‘Initialization Vectors’ for Block Ciphers. In the next chapter we will look at the area of random number generation for database data.

The above book excerpt is from:

Super SQL Server Systems
Turbocharge Database Performance with C++ External Procedures

ISBN: 0-9761573-2-2
Joseph Gama, P. J. Naughter  


Burleson Consulting Remote DB Administration







Burleson is the America's Team

Note: The pages on this site were created as a support and training reference for use by our staff of DBA consultants.  If you find it confusing, please exit this page.

Errata?  SQL Server technology is changing and we strive to update our SQL Server support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:and include the URL for the page.

Burleson Consulting
SQL Server database support


Copyright © 1996 -  2013 by Vaaltech Web Services. All rights reserved.

Hit Counter