by XTIVIA | Jul 2, 2019 | Blog, SQL Server
As a SQL Server DBA, there will be times when you will cross over into the system administrator realm of responsibilities or at a minimum explaining them how to fix errors so your SQL environment runs better. WSFC (windows server failover cluster) is setup for...
by XTIVIA | Jun 13, 2019 | Blog, Database
Whether you pronounce it “S-Q-L” or “sequel,” we interact with SQL, NoSQL, or NewSQL in one way or another everyday, but what exactly is the difference between them? The fact of the matter is that, although they’re all types of databases,...
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 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 Tony Salerno | May 7, 2019 | Blog, Database
Commonly referred to as “Postgres,” PostgreSQL is a free open source object-relational database management system (ORDBMS) with an interface for creating fail-safe environments and committed to preserving data integrity. Since its initial release in 1996,...