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

How to Remove Transparent Data Encryption From a Database

There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent Data Encryption.  Read more...
By Additional Articles 2018/08/14 | Source: Database Journal | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 2,672 reads

Enable FIPS 140-2 Compliance in SQL Server

What is FIPS? How do I use it? What is going to break if I do use it?  Read more...
By Jason Ash 2018/06/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 737 reads

Data Encryption Using Always Encrypted in SQL Server

The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to learn more.  Read more...
By Additional Articles 2018/03/16 | Source: Database Journal | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 3,444 reads

TDE with Automatic Database Seeding

Transparent Data Encryption on an Availability Group and Automatic Database Seeding  Read more...
By Evgeny Garaev 2018/03/08 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: |  Discuss |   Briefcase | 574 reads

How to Enable Transparent Data Encryption

By default, SQL Server does not encrypt data in a SQL Server database in an encrypted format. When SQL Server 2008 was introduced, Microsoft implemented Transparent Data Encryption (TDE). When TDE is enabled on a database SQL Server will encrypt the database as data is written to the disk.  Read more...
Rating:  Rate this |   Briefcase | 2,443 reads

Disk Encryption and The Impact to DBAs

As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.  Read more...
By John F. Tamburo 2018/01/16 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 852 reads

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 | 1,312 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 | 3,456 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 | 4,304 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 | 5,123 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 | 66 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,500 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 | 59 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,098 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 | 129 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 | 115 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,724 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 | 109 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 | 412 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 | 11,112 reads
   Items 1 to 20 of 84    Older >>