Our blog isn’t just a record. It’s a resource.
We know how difficult managing a database can be. Luckily, we’re here to share our experiences troubleshooting, building, improving, and operating them. Browse blogs below, and feel free to comment!
Key Differences Between SQL, NoSQL, and NewSQL
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, each one is very different...
read more
Three Text Highlighting Tricks with PuTTY
PuTTY is a free, cross-platform terminal program that supports SSH, telnet, and raw socket connections. For authentication it supports public key and kerberos single-sign-on. This application, is one of the oldest clients for Microsoft Windows, released by Simon...
read more
PostgreSQL Clustering and Replication Options
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...
read more
CTEs and Client Statistics
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...
read more
Setup AD for AlwaysOn Listener
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...
read more
Database 101, Part 9: Expert Database Services from XTIVIA
Showcasing popular databases in the Database 101 series was meant to provide an introduction to database information and also XTIVIA's exceptional database services. With the introductions out of the way, we'd like to share a little bit about our company and what we...
read more
Installing PostgreSQL on Ubuntu VirtualBox
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...
read more
Database 101, Part 8: Popular Databases – MongoDB
MongoDB is a document-oriented NoSQL database that uses the Binary Serialization Object Notation (BSON) file format — similar to JavaScript Object Notation (JSON) — for versatile structuring and easy database storage. MongoDB has been popularly used by companies...
read more