Configure TDE encrypted database in SQL Server AlwaysOn Availability Group

TDE has been out there since SQL Server 2008 and it is widely used to protect data/log/backup files at rest. When I talked with DBAs sometimes, even with some very experienced DBAs, I still feel there is some confusing around the terms, such as Service Master Key (SMK), Database Master Key (DMK), Certificate and Database…

2

How to setup Microsoft R Server One-box configuration to support AD account via LDAP

One of my customers was asking how to setup Microsoft R Server, basically there are two options: One-box Configuration Enterprise Configuration In this step-by-step POC tutorial, I will show you how to setup One-box configuration to support AD account via LDAP, it covers: Setup One-box configuration on Server side Configure On-box configuration to support AD…

0

Using unbind to downgrade bound R Server 9.1.0

One of my customers recently had a situation that they upgraded their Microsoft R Server to the latest version 9.1.0, and bound it to SQL Server 2016. Then they want to downgrade to SQL Server 2016 built-in MS R version 8.0.3. According to the document – https://docs.microsoft.com/en-us/sql/advanced-analytics/r/use-sqlbindr-exe-to-upgrade-an-instance-of-sql-server, you can surely upgrade it, but how do…

0