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

Content with tag Encryption Rss

   Items 1 to 20 of 98    Older >>
 

How to configure SSL encryption in SQL Server

Tibor Nagy explains how to configure Secure Sockets Layer (SSL) encryption on our SQL Servers, with a trusted certificate.  Read more...
By Additional Articles 2014/08/19 | Source: MSSQLTips.com | Category: ssl
Rating: (not yet rated)  Rate this |   Briefcase | 8,815 reads

Getting Started with Hashing in SQL Server

Encryption brings data into a state which cannot be interpreted by anyone who does not have access to the decryption key, password, or certificates. Hashing brings a string of characters of arbitrary size into a usually shorter fixed-length value or key. Here's how to get started using it.  Read more...
By Additional Articles 2014/08/06 | Source: Database Journal | Category: hashing
Rating:  Rate this |   Briefcase | 8,505 reads

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,094 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 | 2,054 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,404 reads

Double Keys

By Steve Jones 2014/04/22 | Category: encryption
Rating: (not yet rated) |  Discuss |   Briefcase | 1,719 reads

Decryption Keys

By Steve Jones 2014/04/15 | Category: encryption
Rating: (not yet rated) |  Discuss |   Briefcase | 1,524 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,590 reads

Symmetric Key Use

By Steve Jones 2014/04/08 | Category: encryption
Rating: (not yet rated) |  Discuss |   Briefcase | 1,335 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,068 reads

Symmetric Keys

One of the encryption options in SQL Server is symmetric key encryption. This is the type of encryption most people...  Read more...
By Steve Jones 2013/12/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,473 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 | 226 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 | 572 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,035 reads

Alter Certificate

By Steve Jones 2013/09/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,961 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,705 reads

SQL views

By Naseer Ahmad 2013/08/01 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,244 reads

TDE Setup

By Steve Jones 2013/07/26 | Category: encryption
Rating: (not yet rated) |  Discuss |   Briefcase | 1,626 reads

TDE Setup

By Steve Jones 2013/07/18 | Category: encryption
Rating: (not yet rated) |  Discuss |   Briefcase | 1,995 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,961 reads
   Items 1 to 20 of 98    Older >>
 
Tags
security (34)    
editorial (15)    
transparent data encryption (tde) (15)    
blogs (9)    
friday poll (9)    
t-sql (8)    
sql server 2005 (6)    
certificates (5)    
administration (4)    
editorial - ipod (4)    
editorial - wmv (4)    
sql server 2008 (4)    
editorial - mp3 (3)    
views (3)    
asymmetric keys (2)    
backup / recovery (2)    
database master key (dmk) (2)    
hashing (2)    
sql server express (2)    
ssl (2)    
stored procedures (2)    
symmetric keys (2)    
authenticators (1)    
c# (1)    
cryptography (1)    
database design (1)    
database weekly (1)    
deadlock graph trace (1)    
disaster recovery (dr) (1)    
dmv's (1)    
ekm (1)    
hashbytes (1)    
hsm (1)    
md5 (1)    
md5 function password encrypt sql 2005 (1)    
metadata (1)    
object_id (1)    
passwords (1)    
secure programming (1)    
service broker (1)    
sql server 2000 (1)    
symmetric key (1)    
with encryption (1)