Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
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...
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...
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...
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 forced to cancel and delete the AG or wait...
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, Postgres has...
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...
IBM's Db2 (previously DB2 up until 2017) is a popular Relational Database Management System used by businesses of all sizes in the computer software and IT service industries. Originally developed for the relational model, IBM has extended Db2's support to...
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...
Informix is an RDBMS, coincidentally started its life from a company by the name of Relational Database Systems or RDS. The database product was acquired by IBM in 2001 and is now fondly referred to as IBM Informix. Informix is ideal for situations where minimal...
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...