Database Blog

• 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

• Best Practices for Error Handling in Database Stored Procedures

  Jun 29, 2016

  I recently performed an assessment of a large set of Oracle stored procedures and batch scripts that a client uses as part of their build and update process. The problem was that the build process was not very stable. During each build, something would go wrong, such as a table not being created or loaded … Continue reading Best Practices for Error Handling in Database Stored Procedures

  Read more Add new comment

• Ever Dropped an Oracle Table and Wish You Hadn’t?

  Jun 1, 2016

  If you’ve ever dreamed of going to a recycle bin like you can on Windows, and “undropping” an Oracle database table… Oracle has made your dream come true! Introduced with Oracle 10g, Oracle’s recycle bin works a lot like what you’re used to in Windows. When this feature is enabled (the default setting), dropped tables … Continue reading Ever Dropped an Oracle Table and Wish You Hadn’t?

  Read more Add new comment