Because even DBAs need a little holiday humor, and we all know how SQL query plans can go.
SQL Query Plan Karaoke
read more
Database Blog Posts
What’s a Database Health Check?
As a critical component of your business, a healthy database is vital to staff efficiency and customer satisfaction. If you've neglected database maintenance and tuning, chances are you're running into a litany of performance issues. When your database begins to lag,...
The Basics of Database Performance Tuning
Poor database performance bogs down operations, and as the lifeblood of a business, companies can't afford barriers to data access. One of the best ways to navigate past performance issues is by getting a regular database performance audit. Just like a car needs...
Will Migrating to PostgreSQL or MongoDB Save You Money?
One of the most common questions our clients ask us is, "can we save money migrating to an open-source database like PostgreSQL or MongoDB?" The answer is simple: yes. Before we dive into the details, it's important to note that "open source" does not mean free. While...
What is MFA and Why does it Matter?
Multi-Factor Authentication (MFA) is something a lot of IT professionals know about but never want to bring up to their clients. MFA is the next step defense in your everyday battle in protecting your day to day operations. So let's talk about it. What is MFA?...
Sockets, Cores, and Threads, oh my!
What do you mean, exactly, by "CPU"? Once upon a time, computers sat on our desks; we knew exactly how many processors they had; and back then our biggest uncertainty was whether they could handle Y2K. Fast forward to today: our computers have 4, 8 or 16 processors —...
What’s in Our Virtual-DBA Name?
Virtual-DBA came out of XTIVIA's response to an urgent need in the market to limit travel during the dotcom bubble burst. It was vital for our customers to conserve travel resources, both time and money, while getting immediate response on database issues. In that...
Top 10 Things You and Your DBA Can Do to Pivot From the Effects of COVID-19
The effects of COVID-19 continue to disrupt "business as usual." However, there are opportunities for strengthening business processes and even growth that were not present previously. Here is XTIVIA's top 10 list of things your DBA could be doing to help make the...
Ten Factors for Choosing DBA Services
Data is the lifeblood of your business, which means taking care of it is essential for operating your business. Whether your company uses SQL Server, Oracle, Db2, or PostgreSQL, quality database support, maintenance, and protection must be an integral part of your...
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...