Frequently Asked Questions about SQL Server TDE

In an older article, we have discussed about Transparent Data Encryption (TDE) in SQL Server. In this article, we will be answering different frequently asked questions about SQL Server TDE.   What is SQL Server TDE? SQL Server TDE stands for Transparent Data Encryption and it is Microsoft’s technology, based on which SQL Server performs … Read more…

Tip of the Week No.1 – SQL Server Always Encrypted

Check our Tip of the Week, about the SQL Server Always Encrypted feature!   Tip of the Week #1 With Always Encrypted in SQL Server 2016 and later, you can protect sensitive data, by encrypting sensitive data on the application side, without revealing the encryption keys to the Database Engine. To this end, through a … Read more…

How to Enable SSL Certificate-Based Encryption on a SQL Server Failover Cluster

Hi folks. Because enabling an SSL certificate on a SQL Server Failover Cluster, thus enabling encryption for your data in-motion, is a little bit tricky, I decided to write this article in order to help you out a bit, since in the past, I encountered the same difficulties. So, please read on to learn more … Read more…

[DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error – How to Resolve

This article, suggests a way of resolving the below error message, when you are trying to access SQL Server using “Microsoft OLE DB Provider for SQL Server” and TLS 1.0: [DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error Prior to start writing this article, I was thinking of using a title like “How to still use TLS … Read more…

10 Facts About SQL Server Transparent Data Encryption

Transparent Data Encryption known also known as TDE (learn more), encrypts SQL Server, Azure SQL Database and Azure SQL Data Warehouse data and log files on the OS-level. Moreover, a derived benefit is that also SQL Server-based backups of encrypted databases are also encrypted. This type of encryption can be characterized as encrypting data at … Read more…

Should Windows “Built-In\Administrators” Group be SQL Server SysAdmins?

If you worked -or still working- with SQL Server 2005 (or even earlier), you must have noticed that when you installed these SQL Server versions, the local Windows group “Built-In\Administrators” was automatically included in the SQL Server instance along with getting the role “SysAdmin” server role. This actually, when it comes to SQL Server security, … Read more…

Encrypting a SQL Server Database Backup

Encrypting a SQL Server database backup is necessary in many cases, especially when the database has sensitive data. SQL Server provides an easy way to encrypt database backups. Let’s further examine this functionality with a step-by-step example. In this example, we are going to backup a SQL Server 2014 database, encrypt it, and then restore … Read more…

Sneak Peek of SQLArtBits DBA Security Advisor v2.0

[Update: SQLArtBits is Now SQLNetHub!] You can find the latest version of DBA Security Advisor here. On April 5 2017, SQLArtBits releases DBA Security Advisor v2.0. This article gives a sneak peek of the upcoming new release of DBA Security Advisor v2.0. DBA Security Advisor is a powerful tool developed by SQLArtBits that allows Database Administrators (DBAs) … Read more…

Frequent Password Expiration: Time to Revise it?

Until recently, enabling the frequent password expiration option in SQL Server was included in many security best practices. However, recent studies, revised this recommendation and support that it should not be further included in SQL Server’s security best practices. However, if this is the case, how can this recommendation be replaced with new, modern best … Read more…

Why You Need to Secure Your SQL Server Instances

This article, discusses about the necessity of securing your SQL Server instances and databases. Introduction Database Management Systems (DBMSs) store data. They sure have added functionality and a huge set of significant features but again, in the end of the day, they store data. Your data. This makes your DBMSs one of the most valuable … Read more…

Encrypting SQL Server Databases

In this article, we will be discussing about the different available options, for encrypting SQL Server databases.   The Need for Data Encryption In corporate environments there is always the requirement/policy of data protection. Data is the most valuable asset in every organization, after its human resources of course, as it is with data where … Read more…

Security Changes in SQL Server 2008

SQL Server 2008, among other introduced significant security changes that enhance the database administrators applying an even stricter security policy on the SQL Server instances. This article discusses the security changes in SQL Server 2008.   Major Security Changes in SQL Server 2008 Besides the changes in the Windows local groups that are created during … Read more…