As more and more businesses move their operations to the cloud, the importance of remote database administration (DBA) services has increased significantly. However, working with a remote DBA managed service company can come with its fair share of risks. In this blog...
Database Blog Posts
The Evolution of DBAs: Why the Role Isn’t Obsolete Yet
As businesses increasingly shift towards cloud computing, one question that arises is whether the role of the traditional Database Administrator (DBA) is becoming obsolete. With managed cloud databases like Amazon RDS and others, many companies are finding it easier...
Choosing a Remote Database Administration Managed Service Vendor: 10 Key Factors to Consider
As more businesses embrace remote work and cloud-based technologies, the need for remote database administration (DBA) services has increased. A remote DBA managed service vendor can provide businesses with the technical expertise they need to manage and maintain...
Why Hire a Remote DBA? And More Specifically, Why Hire XTIVIA Virtual-DBA?
In today's fast-paced business environment, organizations need to be agile and efficient to remain competitive. One way to achieve this is by utilizing a remote DBA managed service. Remote DBA services provide businesses with access to experienced database...
How to Maximize Security When Working with a Remote Database Administration Managed Service Company
When it comes to managing your database, security should always be a top priority. This is particularly true when working with a remote database administration managed service company. Here are some tips on how to maximize security when working with a remote database...
Protecting Criminal Justice Information
In order for XTIVIA to provide DBA managed services to governmental agencies where the FBI's Criminal Justice Information Services Division (CJIS) Security Policy is required, CJIS compliance was necessary. CJIS is a set of standards for accessing criminal justice...
Automating Log Rotation with Logrotate
Rotating MySQL logs is important because logs can take up a lot of disk space if left unmanaged. For example, an untuned database can lead to a lot of slow queries being logged. The error log can become large if it includes notes and warnings. Additionally, binlogs...
Migrating from SUPER to Dynamic Privileges
When performing health checks on a database, I look at how many users are granted SUPER privileges. If you're reading this, you know why. SUPER privileges pose a potential security risk and should be limited to a few users that need this far-reaching access to...
Explaining Database Normalization Like You’re Five
Normalization is not that complicated. In fact, the beauty of these rules is that you may not know you're already applying them in your database design. To demonstrate, over the course of this multi-part series, we'll be covering the three generally accepted levels of...
SQL Query Plan Karaoke
Because even DBAs need a little holiday humor, and we all know how SQL query plans can go.