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...
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...
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...
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...
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...
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...
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...
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...
Because even DBAs need a little holiday humor, and we all know how SQL query plans can go.
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,...