SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Encryption Rss

Search for any content tagged encryption

   Items 1 to 20 of 78    Older >>
 

Using Database Master Keys in SQL Server

Learn the basics of Database Master Keys and how you can use them in SQL Server.  Read more...
By Steve Jones 2017/08/15 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 863 reads

Encrypting SQL Server: Dynamic Data Masking

Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an application. It doesn't encrypt the data, and a knowledgeable SQL user can defeat it. However it provides a simple way to administer from the database what data the various users of a database application can and can not see, making it a useful tool for the developer.  Read more...
By Additional Articles 2017/05/16 | Source: SimpleTalk | Category: encryption
Rating:  Rate this |   Briefcase | 2,867 reads

SQL Server Encryption: Always Encrypted

Is 'Always Encrypted' SQL Server 2016's most widely important new feature? It is significant that 'Always Encrypted' in SQL Server is in all editions of SQL Server. Because of the increasing importance of encryption to data governance, it allows encryption for the sensitive application data for everywhere beyond the application's client connection, including network, server, database and storage. Robert Sheldon explains what it is, why you should try it out, and how to set about it.  Read more...
By Additional Articles 2017/04/10 | Source: SimpleTalk | Category: always encrypted
Rating: (not yet rated)  Rate this |   Briefcase | 3,836 reads

Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data

SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very effective way of doing this. In the first in a series of articles on the theme of SQL Server Encryption, Robert Sheldon once more makes it all seem easy.  Read more...
By Additional Articles 2017/02/27 | Source: SimpleTalk | Category: encryption
Rating:  Rate this |   Briefcase | 4,730 reads

Encryption Keys Matter

Protecting the keys used for encrypion can really matter for companies, and in today's complex world, that can be difficult. Monitoring becomes important to helping here.  Read more...
By Steve Jones 2016/09/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

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

You work in a shop that puts 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 for companies that use the SQL Server layer to perform  Read more...
By Additional Articles 2016/07/18 | Source: MSSQLTips.com | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 3,254 reads

SQL Server 2016: The Data Protection Version

Today Steve Jones looks at the security enhancements in SQL Server 2016  Read more...
By Steve Jones 2016/02/24 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

SMKs, DMKs, Certificates for TDE and Encrypted Backups

This article details SMKs, DMKs and certificates in SQL Server as they relate to Transparent Data Encryption and Encrypted Backups.  Read more...
By Perry Whittle 2015/12/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,002 reads

The Auditor Attack Vector

Steve Jones shares a story about losing data today.  Read more...
By Steve Jones 2015/12/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 127 reads

Source Code Security

The code you use may contain security information. Be extra careful in this case, especially when you use encryption.  Read more...
By Steve Jones 2015/03/31 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

Finding Encrypted Data in a SQL Server Database

The easiest way to determine if there is encrypted data in a database is to get that information from whoever wrote the application. Aside from that, there are a few things you can look for which would suggest that you have encrypted data in a given database.  Read more...
By Additional Articles 2015/01/27 | Source: MSSQLTips.com | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 7,462 reads

Test Your Situation

One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.  Read more...
By Steve Jones 2015/01/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

A Fundamental Security Mistake

Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.  Read more...
By Steve Jones 2014/11/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 409 reads

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 | 10,903 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 | 10,125 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 | 6,129 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,746 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 | 4,153 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 | 4,108 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 | 4,000 reads
   Items 1 to 20 of 78    Older >>