by XTIVIA | May 31, 2019 | Blog, PostgreSQL
Figuring out when to cluster can be a mountain to climb in itself, but combining that with figuring out which software to use can often be an insurmountable task. In this article I will go over the clustering options available for PostgreSQL and highlight their...
by XTIVIA | May 28, 2019 | Blog, 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 | Blog, 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 16, 2019 | Blog, PostgreSQL
PostgreSQL on Ubuntu VirtualBox When you first start diving into a new database it’s always difficult to know what environment parameters and resources to use to just get started. I will walk you through setting up VirtualBox, Ubuntu, and PostgreSQL to get you...
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 | May 2, 2019 | Blog, MySQL
Depending on your operating system and individual environments, the upgrade process can vary. Release notes should be reviewed for differences between database versions, which may affect your environment. Though we offer professional advice on how to upgrade MySQL 5.5...
