Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
SQL Server

Home >Search > Articles & Samples > SQL Server > Encryption

What's New - What's Hot
Encrypting Sensitive Data in a Database     
Total Hits: 416  |  Today: 0Author: Scott Mitchell      Rating:  
Read Reviews | Write Review |  Your Rating: 

There are a plethora of steps one can take to harden their data-drive applications from malicious hackers. The first and most important step is to harden your database software. Do you have the latest service packs installed? If you're using Microsoft SQL Server, have you chosen a sufficiently complex password for the sa account? Is your database configured only to accept Windows authentication? For more information on improving your database's security see 10 Steps to Help Secure SQL Server 200...

HOW TO: Enable SSL Encryption for SQL Server 2000 with Microsoft Management Console     
Total Hits: 1954  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to install a certificate on a that is running SQL Server 2000 by using Microsoft Management Console (MMC) and describes how to enable SSL Encryption at the server, or for specific clients....

How to Encrypt and Decrypt a Password  Version: 0.00     Price: $0.00  
Total Hits: 22  |  Today: 0Author: Syed Shakeer      Rating:  
Read Reviews | Write Review |  Your Rating: 

EncryptByPassPhrase uses the Triple DES algorithm to encrypt the text passed in.

Syntax: ENCRYPTBYPASSPHRASE ('PASSPHRASE',,column_name or 'text')

In this statement, PASSPHRASE specifies the data string to be used to derive an encryption key,and column_name data type shoulb be VarBinary....

Database Encryption in SQL Server 2008 Enterprise Edition  Version: 0.00     Price: $0.00  
Total Hits: 22  |  Today: 0Author: Sudhir Goswami      Rating:  
Read Reviews | Write Review |  Your Rating: 

With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by using TDE, or the file-level encryption options provided by Windows. TDE is the optimal choice for bulk encryption to meet regulatory compliance or corporate data security standards. TDE works at the file level, which is similar to two Windows features: the Encrypting File System (EFS) and BitLocker Drive E...

Managing SQL Server 2005 Master Keys for Encryption     
Total Hits: 258  |  Today: 0Author: Tim Cullen      Rating:  
Read Reviews | Write Review |  Your Rating: 

I recently accepted the challenge of designing a database for an employee application, and the first thought to cross my mind was," I will need to encrypt at least one piece of data". Along with SQL Server 2005 came the native ability to encrypt data in the database. Prior versions depended on third-party tools or encryption via the front end application. In this four-tip series we will cover the objects needed and steps required to encrypt data using SQL Server 2005:
* Database Master Ke...

Regular Expressions Make Pattern Matching And Data Extraction Easier     
Total Hits: 110  |  Today: 0Author: David Banister      Rating:  
Read Reviews | Write Review |  Your Rating: 

Although T-SQL is extremely powerful for most data processing, it provides little support for text analysis or manipulation. Attempting to perform any sophisticated text analysis using the built-in string functions results in massively large functions and stored procedures that are difficult to debug and maintain. Is there a better way? In fact, regular expressions provide a much more efficient and elegant solution. It is easy to see how they would be helpful for comparing text to identify recor...

How to Encrypt and Decrypt a Text  Version: 0.00     Price: $0.00  
Total Hits: 33  |  Today: 0Author: Syed Shakeer      Rating:  
Read Reviews | Write Review |  Your Rating: 

This Article explains you how to Encrypt and Decrypt a text. you can encrypt a password and can store a password as VarBinary in a column by using EncryptByPassPhrase function. Encrypted column can be decrypted by using DECRYPTBYPASSPHRASE function....

Encrpting the Column Values to provide Security Feature     
Total Hits: 111  |  Today: 0Author: Sivsakthi.vijay      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2005 provides encryption as a new feature to protect data against the attacks of hackers. Hackers may be able to get hold of the database or tables, but they wouldn't understand the data or be able to use it. It is very important to encrypt crucial security related data when stored in the database, as well while transmitting across a network between the client and the server....

Using MD5 Encryption with C# and MSSQL 2000  Version: 0.00     Price: $0.00  
Total Hits: 75  |  Today: 0Author: UsualDosage      Rating:  
Read Reviews | Write Review |  Your Rating: 

The .NET Framework provides developers with some easy to use classes for modern encryption. One of the more popular methods these days is the use of MD5 encryption. MD5 encryption, to quote from RFC 1232, "takes as input a message of arbitrary length and produces as output a 128-bit "fingerprint" or "message digest" of the input. It is conjectured that it is computationally infeasible to produce two messages having the same message digest, or to produce any message having a given prespecified ta...

Natively Encrypting Social Security Numbers in SQL Server 2005     
Total Hits: 251  |  Today: 0Author: Tim Cullen      Rating:  
Read Reviews | Write Review |  Your Rating: 

I need to encrypt data in my SQL Server 2005 database and currently have a Database Master Key and Certificate installed. Can I encrypt using only a certificate? The answer is "yes". Symmetric and asymmetric keys are not required for the encryption/decryption process, although they do add another layer of security to the mix. When deciding on an encryption/decryption process, you must think about who needs to see what data. If there are different levels of security needed then multiple certifica...

SQL Server 2005 Encryption - Certificates 101     
Total Hits: 260  |  Today: 0Author: Tim Cullen      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have a Database Master Key created in the database. Can I start encrypting data in my database now? The answer is "not yet". A Database Master Key per se' cannot encrypt data. You either need another key or a certificate. In this second tip of a four-part series we'll cover all things Certificates.
NOTE - For the first tip in these series, please reference - Managing SQL Server 2005 Master Keys for Encryption....

Disclaimer - Privacy
© 2002-2017