Transparent Data Encryption (TDE) in SQL Server in an AlwaysOn Availability Group on Example

Availability Groups are fantastic for High Availability/Disaster Recovery solutions, and I’m sure that fellow DBAs will agree with me. However, there will be times when we must consider certain precautions and extra steps carefully to avoid unwanted surprises. For instance, any Secondary Replica becomes the current Primary Replica for whatever reason, and our goal is to not let it happen.

CodingSight-Dealing with encryption of databases in an AlwaysOn availability group scenario
Read More

How to Install Ubuntu 18.04 and SQL Server 2019 on Linux

The previous article explained the creation of a virtual machine using Oracle VM Virtual machine. Now, we will learn how to install Ubuntu 18.04 and SQL Server 2019 on Linux.

Install Ubuntu Linux

First, we need an operating system ISO file. Once the file is downloaded, we mount it on a virtual disk drive:

Launch Oracle VM Virtual Machine Manager and right-click on LinuxSQL01. Then click Settings.

Read More

Сreating a Virtual Machine With Oracle VM Virtual Box

Microsoft announced cross-platform support of SQL Server – the SQL Server 2017 and SQL Server 2019 work on Microsoft Windows and Linux. We can install SQL Server 2017 and higher on Red Hat Enterprise Linux, Ubuntu, and SUSE Enterprise Server. We can also set up high availability and disaster recovery mechanism for SQL Server on Linux like SQL Server Log shipping and AlwaysOn Availability Group.

CodingSight - Сreating a Virtual Machine With Oracle VM Virtual Box
Read More