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...
by XTIVIA | Apr 25, 2019 | Blog, PostgreSQL
Query Queues are set up in Redshift Workload Management and are designed to give the administrator freedom to assign more or fewer resources to given groups or users. On occasion, you will need to inspect these queues to see which queries are running in which queues...
by XTIVIA | Apr 11, 2019 | Blog, PostgreSQL
The number one priority in any production environment, beyond availability, is performance. End users want a smooth and quick experience, while the pressure mounts on you to deliver faster response times. Since PostgreSQL monitoring is arguably one of the most...
