Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Security > Encryption

Encryption

1-20 of 27     Previous     Next
Encrypt and Decrypt Configuration File Sections from a Command Line
by Deepak Choudhari
When you're delivering an application or testing it, it's very convenient to be able to encrypt and decrypt sections of a configuration file from a command line.
An Improved szEncryptDecrypt VB6 Funtion
by Scott Likely
The szEncryptDecrypt function in a previous tip did not handle unicode strings properly, but otherwise worked well. The changes in the following version should work for any string by explicitly converting each character to ASCII and back.
Using the SecureString Class
by Srinath MS
NET 2.0's System.Security namespace includes the SecureString class, which lets you create encrypted strings and delete them from memory when they're no longer needed.
Add Two Long Numbers Together Without Causing an Overflow Error
by David Day
This function adds two long numbers together as if they were unsigned, and does not cause an overflow error. You may need this when implementing the SHA-1 Hashing function.
Use Oracle Obfuscation to Encrypt Data Securely
by Sushil Srivastava
Learn how to encrypt data—like passwords and other confidential information—using Oracle Obfuscation techniques.
Who Is Using the Oracle Database?
by Shiv Kumar
...
Encrypting Stored Procedures
by Rick Codrington
When creating stored procedures, there will be occasions where a certain procedure definition should not be viewed. Using the WITH ENCRYPTION clause stores the procedure definition in an ...
Undocumented Encrypt and Decrypt Functions in SQL Server 7.0
by Andrew Holliday
There are two undocumented encryption functions. They are not supported by Microsoft, and I have had problems with some SQL Server service packs when using these functions. That being said, the ...
Use Screen-Saver Passwords
by Marco Bellinaso
When you write a screen saver in C and the Windows SDK, a static library (SCRNSAVE.lib) allows you to create custom dialogs to change and request the password. But in VB you can't use this library. ...
Hide Implementation Details of Stored Procedures
by Deepak Pant
You can hide the implementation details of your stored procedures from end users of the application using WITH ENCRYPTION option. ENCRYPTION indicates that SQL Server encrypts the syscomments table ...
Use Stored Procedures for Updates and Insertions
by Jai Bardhan
Coding static SQL in an Active Server Page (ASP) is perhaps the easiest way to provide dynamic data content in Web pages. However, you should try avoiding this; instead use a stored procedure ...
Use Stored Procedures in Place of Embedded SQL
by Deepak Pant
Stored procedures offer many advantages over dynamic SQL, including improved performance and scalability. The SQL code in a stored procedure is parsed and normalized when you create it. Stored ...
Log Onto SQL Server Using Windows NT Authentication
by Deepak Pant
Here is a simple function you can use to connect to SQL Server. This function attempts to connect to the server either using the default SQL Server authentication or Windows NT authentication. If ...
Identify Host That Called Remote Method
by Brett Spell
When creating remote objects for use with Java's Remote Method Invocation (RMI), you'll often extend java.rmi.server.UnicastRemoteObject. When you do extend UnicastRemoteObject, it becomes easy ...
Automatically Execute Stored Procedures When Starting SQL Server
by KulBhushan Sharma
Use sp_procoption to execute a stored procedure automatically at the time of starting SQL server. The stored procedure that needs to be executed should be created in the master database and owned ...
Return the Program Name for the Current Session in SQL Server
by Jai Bardhan
SQL Server 6.5 has an APP_NAME() function which returns the program name for the current session. This function is useful for tracking which client applications are running processes in SQL Server or ...
Lock the Back Door Too
by Joseph Lax
An extended stored procedure called xp_cmdshell causes SQL Server to spawn a command shell and execute the command given as a parameter. For example, xp_cmdshell 'dir c:\mssql\backup' would return a ...
Create Application Roles in SQL Server 7
by Joseph Lax
Developers commonly want to ensure that a user accesses only the data through their application. After all, not every person should be let near a server with Microsoft Access. However, if a user has ...
Keep Good Habits to Avoid Fatal Errors to Your Database
by Joseph Lax
As a database administrator, you will unfortunately be called upon to respond at times when you are not at your best. It is exactly at those times that you need good habits to protect you. One of my ...
Encrypt a String Easily
by Rob Bovey
This quick and dirty encryption/decryption function takes whatever string you pass it, assigns it to a byte array, Xor's each byte by a constant, then returns the string. The offsetting done on every ...
1-20 of 27     Previous     Next
Sitemap