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 63    Older >>
 

Granular or Cell Level Encryption in SQL Server

Arshad Ali demonstrates granular level encryption in detail and explains how it differs from Transparent Data Encryption (TDE).  Read more...
By Additional Articles 2014/07/04 | Source: Database Journal | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 5,030 reads

Using Encrypted Backups in SQL Server 2014

This article details encrypted backups and how they are implemented in SQL Server 2014.  Read more...
By Perry Whittle 2014/05/15 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 1,999 reads

Administering Database Master Keys in SQL Server

A short piece that gives you the basics of how to administer the database master keys that form the basis for encryption inside of your databases.  Read more...
By Steve Jones 2014/05/12 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 3,357 reads

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 | 3,565 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 | 3,033 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 | 218 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 | 570 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 | 4,020 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,695 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,936 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 | 105 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,794 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,585 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 | 105 reads

TDE and SQL Server Databases

The article discusses and demonstrates TDE for SQL Server databases  Read more...
Rating: |  Discuss |   Briefcase | 5,602 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,047 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 | 238 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 | 204 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,320 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 | 236 reads
   Items 1 to 20 of 63    Older >>