Database Blog

• Tales of Business Continuity and Disaster Recovery Planning

  Oct 2, 2017

  Planning for Disaster As we think about the enormous cleanup effort taking place in the wake of Harvey, Irma, and Maria, we are reminded of the importance of planning to keep your business up and running when disaster strikes.  In this blog post I share the thoughts of an expert in the field of Business … Continue reading Tales of Business Continuity and Disaster Recovery Planning

  Read more Add new comment

• Database Backups and Gasoline Leaks

  Sep 5, 2017

  How is a database backup like a portable generator with a gasoline leak? And why should you care on a beautiful sunny September morning? How does any of this relate to Business Disaster Recovery and Business Continuity planning and testing?  Read On! Lack of Preparation Until Superstorm Sandy in 2012, we had lived in our NJ town for … Continue reading Database Backups and Gasoline Leaks

  Read more Add new comment

• Architect Your Oracle Database for Efficient Backup and Recovery

  Aug 3, 2017

  Architecting for Backup and Recovery Efficiency with Oracle RMAN Database architecture is critical to achieving many business objectives. These include application performance, business continuity, security, and geographic distribution.  This article will explore another often overlooked objective that can be influenced by the database architecture: backup and recovery efficiency. Very large databases are common in today’s business … Continue reading Architect Your Oracle Database for Efficient Backup and Recovery

  Read more Add new comment

• The Cloud Does Not Exist!

  Jul 21, 2017

  “Lets Move to The Cloud!” We often hear people talk about moving their business or their data center or their software to “The Cloud“.  For many, this concept seems confusing and vague. That’s because The Cloud does not exist! There is no “The Cloud”. In reality, there are many clouds. And therefore we can’t  just decide to … Continue reading The Cloud Does Not Exist!

  Read more Add new comment

• Duplicating and Recovering Oracle Databases with RMAN

  Jul 5, 2017

  Oracle Recovery Manager Purpose and History Oracle Recovery Manager (RMAN) was developed essentially as a way to more effectively backup and recover Oracle databases, as an automation mechanism for the same, and as a way to keep track of and managing backup sets. It was introduced in version 8 of the Oracle database, so it … Continue reading Duplicating and Recovering Oracle Databases with RMAN

  Read more Add new comment

• Oracle Virtual Private Database — Granting Just Enough Access

  Jun 1, 2017

  Robust Access Control at the Database Layer   Many Companies struggle with the difficult problem of providing fine grained access control at the database layer to sensitive data . We will discuss Oracle’s Virtual Private Database feature which provides a robust way of handling this problem for all types of database users. Security vs Effectiveness Securing access … Continue reading Oracle Virtual Private Database — Granting Just Enough Access

  Read more Add new comment

• Pursuing Excellence: Golf and Software Development

  May 11, 2017

  How to Improve After a particularly bad round of golf recently,   I was thinking about how to improve my game.  I thought about how we go about making improvements in anything we do. We evaluate what we have done,  and based on that evaluation, we try to make changes that we think will help us get … Continue reading Pursuing Excellence: Golf and Software Development

  Read more Add new comment

• Plugging the Database Audit Trail Gap

  Apr 18, 2017

     The Importance of Database Audit Trails and Security Assessments Database audit trails are critical tools for discovery, investigation, and prosecution of cyber crimes ranging from credit card theft to malicious activity by ex-employees to corporate espionage.  And database security assessments are critical tools for preventing such activity. But an audit trail or a security assessment is only as good … Continue reading Plugging the Database Audit Trail Gap

  Read more Add new comment

• Using Oracle GoldenGate for real time data replication and integration.

  Sep 23, 2016

  Oracle GoldenGate is Oracle’s best-of-breed, strategic solution for real-time data replication and integration. It offers a rapid, robust and low-overhead approach for moving small or large volumes of transactional data between diverse operational and analytical systems—including not just various Oracle Database versions but also non-Oracle databases like SQL Server, Sybase, IBM DB2 and others. Though … Continue reading Using Oracle GoldenGate for real time data replication and integration.

  Read more Add new comment

• Time to Validate Your Database Backup

  Jul 8, 2016

  Another new client, Another bad backup I originally wrote this post in July but I am updating it today because it is so important.  Yesterday we did an initial Oracle Database Health Check for another new client and found yet again that their backups are useless. This time the client was taking backups regularly, but … Continue reading Time to Validate Your Database Backup

  Read more Add new comment