Datavail Experts Blog

Where the DBA Experts Share Their Thoughts

Top 10 Reasons DBAs Quit

06/05/2013 - By admin — The role of the DBA is an anomaly in the IT environment. DBAs are often extremely critical yet hidden from view; highly paid yet individual contributors; and very knowledgeable yet rarely consulted. So ...

Read more

No comment
Read/Write Comment

FRM-40501: Could not reserve record [2 tries]; Oracle Apps Record-Locking

06/05/2013 - By Chuck Edwards — One of your end users attempts to modify a record, and the user is prompted with a dialog box asking “Could not reserve record [2 tries]. Keep trying?” The user answers “yes” and ...

Read more

No comment
Read/Write Comment

Business Continuity Planning: Disaster Recovery in the Cloud

03/17/2013 - By Chuck Edwards — What can be done to protect against outages from major cloud providers?

Read more

SQL and NoSQL Database Comparison: When is a NoSQL database a better option than a “traditional” RDBMS?

02/28/2013 - By admin — The departure of NoSQL from RDBMS comes in the form of optimized retrieval and appending of data, high level of scalability with relative low costs, ease of parallel programming, flexibility of data content over data structures, ease of working with non-traditional data, and rapid development.

Read more

No comment
Read/Write Comment

InnoDB Conversion to File Per Table

04/23/2012 - By Charleste King — Your MySQL database was working well, humming along nicely, but quite suddenly performance went south, especially during periods of heavy usage.

Read more

No comment
Read/Write Comment