Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Encryption Rss

Search for any content tagged encryption

   Items 1 to 20 of 60    Older >>
 

How much overhead does encryption add to a SQL Server query

If you have been in the information technology industry long enough, you have probably heard the expression "this adds overhead" when discussing any extra processing added on to what is considered normal processing. Dallas Snider answers the question of additional overhead caused by encryption.  Read more...
By Additional Articles 2014/04/09 | Source: MSSQLTips.com | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 2,835 reads

Database Master Key Error After Database Restore

When restoring a database to another server, you may get a master key error if using symmetric keys   Read more...
Rating: |  Discuss |   Briefcase | 2,894 reads

Encrypt Everything

Yahoo recently announced they are encrypting their traffic between data centers. Steve Jones thinks we should encrypt all traffic.  Read more...
By Steve Jones 2013/12/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 195 reads

Encrypting SQL Code

This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.  Read more...
By Steve Jones 2013/11/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 568 reads

Using Views to Expose Encrypted Data in SQL Server

I'm using SQL Server's built-in encryption to hide data in one of my SQL Server databases, but this is a reporting system and my end users need to be able to query the data without having to remember the specialized decryption functions. Is there a way to do this? Yes, there is, via the use of views.  Read more...
By Additional Articles 2013/10/29 | Source: MSSQLTips.com | Category: views
Rating:  Rate this |   Briefcase | 3,986 reads

Understanding the importance of key length with the SQL Server asymmetric encryption algorithms

K. Brian Kelly is trying to use SQL Server's built-in encryption and sees there are three different options available for an asymmetric key, corresponding to key length. What's the impact of the key length?  Read more...
By Additional Articles 2013/08/12 | Source: MSSQLTips.com | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 2,657 reads

Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions

Some companies put business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual in companies that use the SQL Server layer to perform business tasks, such as finance operations, or incorporate application functionality into the programmability layer. Here's a tip to preserve secrecy on some procedures, views or functions in order to maintain security.  Read more...
By Additional Articles 2013/07/16 | Source: MSSQLTips.com | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 2,884 reads

Algorithm Secrecy is not Security

This week Steve Jones talks encryption and why you shouldn't be implementing anything you've invented.  Read more...
By Steve Jones 2013/03/18 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 104 reads

Securing SQL Server: Vulnerabilities You Might Not Have Considered

A short look at the vulnerabilities your data may be susceptible to outside of the database tables.   Read more...
By Ashvin Kamaraju 2013/03/07 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 5,792 reads

Data Insecurity: A Perspective on Data Encryption

The focus of this paper is on the protection of PII data stored within a database using encryption technologies.  Read more...
By Ron Johnson 2013/03/07 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 1,578 reads

Encryption Not Restriction

Encryption keys for services in the cloud should be maintained by the customer, according to Steve Jones. It's actually a good idea for all of your data.  Read more...
By Steve Jones 2013/01/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

TDE and SQL Server Databases

The article discusses and demonstrates TDE for SQL Server databases  Read more...
Rating: |  Discuss |   Briefcase | 5,556 reads

TDE Setup and Administration Scripts

A comprehensive set of scripts to setup and operate TDE for a SQL Server.  Read more...
By Sean Elliott 2012/08/10 (first published: 2011/03/08) | Source: SQLServerCentral.com | Category: transparent data encryption (tde)
Rating: |  Discuss |   Briefcase | 37,016 reads

We Need to Learn Encryption

With all the recent worms and attacks out there, it's only a matter of time before someone focuses more on databases. With that in mind, Steve Jones thinks it's important we learn and use encryption and better security now.  Read more...
By Steve Jones 2012/06/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 237 reads

Encryption in Production

This Friday Steve Jones wants to know if you are using encryption in your production system and if so, how is it working? Can you handle DR situations?  Read more...
By Steve Jones 2012/02/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 199 reads

SQL Server Column Level Encryption Example using Symmetric Keys

With data stored in tables, you have a few options to protect data. Check out this tip to learn more about column level encryption.  Read more...
By Additional Articles 2011/12/14 | Source: MSSQLTips.com | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 5,292 reads

Encryption Works

Encryption is supposed to protect data, and it appears to be working as police and authorities are often stymied by encrypted disks. Steve Jones recommends you encrypt your disks on all your machines.  Read more...
By Steve Jones 2011/12/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 233 reads

Understanding Security

It is important for data professionals to understand security, but it's also important for end users that must handle data. However we have a lot of work to do to make that easier since Steve Jones thinks many IT pros struggle with this concept.  Read more...
By Steve Jones 2011/06/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 247 reads

TDE Setup and Administration Scripts

A comprehensive set of scripts to setup and operate TDE for a SQL Server.  Read more...
By Sean Elliott 2012/08/10 (first published: 2011/03/08) | Source: SQLServerCentral.com | Category: transparent data encryption (tde)
Rating: |  Discuss |   Briefcase | 37,016 reads

Column-Level Encryption in SQL Server

Beginning with SQL Server 2005, column-level encryption and decryption capabilities were made available within the database, providing a solution for situations where one-off types of data need to be secured beyond your existing authorization, authentication or firewall settings. This article provides an overview and example of securing a column using native SQL Server cryptography functions.  Read more...
By Additional Articles 2011/02/18 | Source: Database Journal | Category: encryption
Rating:  Rate this |   Briefcase | 4,516 reads
   Items 1 to 20 of 60    Older >>