by XTIVIA | May 28, 2019 | SQL Server
CTEs may not be used for performance but there are times they could help you from a performance standpoint. The following example uses the same logic written in a way to use three different types of temporary objects. It shows what is done with each process using...
by XTIVIA | May 23, 2019 | SQL Server
When you create a new Availability Group there are a couple of administrative tasks that should be completed before creating your Availability Group within SQL Server. This will elevate any domain permission issues when you are trying to create your Availability Group...
by XTIVIA | May 9, 2019 | 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 | 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 | Nov 15, 2018 | SQL Server
There are times when a Developer or DBA needs to determine the best performance options with transferring data through a linked server from point A to point B but may not know the best way to do it. In the following example, I am going to show you the differences...
by XTIVIA | Nov 1, 2018 | SQL Server
Directory Tree: In Microsoft (MS) Windows, the C:\ drive is where your operating system (OS), programs, and other files typically reside. In Linux, this is known as the “root” directory and is represented with the forward slash character ( / ). In Windows,...
