Remote Database Administration On-Shore

Database administration is crucial for most businesses, and recently the trend has returned to keeping all aspects of DBA work on-shore, instead of outsourcing it to companies’ off-shore. There are definite benefits to keeping your rDBA in the same US time-zone as your business, as well as reasons outsourcing is no longer a viable solution. […]

An Introduction to Database Services

Recently, I spoke to a client who wanted to separate users into distinct groups in one of their customer-facing databases.  The client wanted to measure each group’s resource consumption so they could start to move to an “on-demand” business model and wanted to prevent one group from consuming excessive amounts of database resources at the […]

Moving to a Cloud Vendor

The cloud has developed rapidly over the past few years, and with it a growing number of increasingly robust cloud-based services have arisen alongside it. This in turn has led many companies to consider a switch to cloud services. However, since cloud systems are still a new and emerging field, it has proven challenging for […]

Leveraging Data: How to Improve Your Business

Understanding the information that your business is collecting is crucial, but learning how to leverage that information to better your business relationships is by far more important. Often times, the information is gathered but not necessarily sorted into a digestible or useful forms and therefore requires you to sift through the information and figure out […]

Understanding UNDO

Sooner or later, every Oracle DBA will hit a problem of some sort that is related to the concept of Oracle “Undo”. The Oracle Undo performs a few very important functions in the database; these being the support of read-consistent queries and Flashback queries, supporting transactions (COMMIT and ROLLBACK), and recovering from database crashes. Along […]