by XTIVIA | May 9, 2019 | Blog, SQL Server
I had an issue where I was trying to create a new Availability Group. During the creation process, it sits at the “Joining ‘DBName’ to availability group ‘AGName’ on ‘servername'” step for a very long time. You are either...
by XTIVIA | Apr 4, 2019 | Blog, SQL Server
Transparent Data Encryption(TDE) encrypts SQL and azure database files by encrypting data at rest. In a situation where your physical media such as data, log and backup files get stolen the malicious party can restore/attach the database and retrieve data. TDE...
by XTIVIA | Sep 27, 2018 | Blog, SQL Server
AlwaysOn Availability Group (AG) is one of my favorite features in SQL Server and is worth considering when using SQL server 2012 or greater. One of the nicest features in AlwaysOn AG is that in a single subnet environment it can be totally transparent to your...
by XTIVIA | Apr 4, 2017 | Blog, SQL Server
I was recently given a task to move a few multi-terabyte databases inside of an availability group from SAN A to SAN B within a 10-minute window. The good news was there was plenty of time to plan and prepare. For the purpose of this example, I will be using a very...
by XTIVIA | Mar 14, 2017 | Blog, SQL Server
There are situations where you would want to change the Windows cluster configuration so a failover does NOT occur. Failovers can occur due to quorum (error: The Cluster service is shutting down because quorum was lost) can’t be reached for a short period of...