Database Blog

  • Plugging the Database Audit Trail Gap

    by Robert Buda | Apr 18, 2017 | Best Practices , Database Security , Oracle

    Reading Time: 4 minutes    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 as the information that it captures. Many audit trails and security assessments take you only so far because of the way…..

    Read more Add new comment
  • Using Oracle GoldenGate for real time data replication and integration.

    by Robert Buda | Sep 23, 2016 | Best Practices , Database , Database Architecture , Oracle , Oracle DBA

    Reading Time: 2 minutes 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 extremely powerful and flexible, Oracle GoldenGate is straightforward to install and configure. Its transformation, filtering and custom processing features make…..

    Read more Add new comment
  • Time to Validate Your Database Backup

    by Robert Buda | Jul 8, 2016 | Backup and Recovery , Best Practices , Oracle , SQL Server

    Reading Time: 2 minutes 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 was not preparing the database first and was just copying the database files. Unfortunately this renders the backup useless. Here…..

    Read more Add new comment
  • Best Practices for Error Handling in Database Stored Procedures

    by Robert Buda | Jun 29, 2016 | Best Practices , error handling , Oracle , Oracle DBA

    Reading Time: 3 minutes 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 as it should be, and it would take the development team a long time to figure out just what went…..

    Read more Add new comment
  • Ever Dropped an Oracle Table and Wish You Hadn’t?

    by Robert Buda | Jun 1, 2016 | Best Practices , Data Dictionary , Oracle , Oracle DBA

    Reading Time: 2 minutes 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 don’t actually get deleted. Instead, they “land” in the recycle bin and can be restored. The recycle bin is actually…..

    Read more Add new comment
  • Architecting to Maximize Recovery Options in Oracle

    by Robert Buda | Apr 21, 2016 | Backup and Recovery , Best Practices , Database Architecture , Oracle DBA

    Reading Time: 2 minutes I recently received a frantic call from a client that believed they have been hacked and had to quickly recover data. They said that data belonging to two or more of their customers had been lost. Our customer functions essentially as an application service provider (ASP). Their customers’ data is in an Oracle database that our client manages. Our client organizes this database such that each of its customers’ applications is served by a separate…..

    Read more Add new comment
  • Do You Know If Your Data Backup and Recovery Strategy Is Working… Or Not?

    by Robert Buda | Feb 1, 2016 | Backup and Recovery , Best Practices

    Reading Time: 2 minutes To mitigate the business impacts of downtime and data loss, every Oracle database must be recoverable. This means every Oracle shop needs a strong backup and recovery strategy—one that takes into account the probabilities of hardware, software, network or procedural failure(s) in your current environment.

    Read more Add new comment
  • Tracking Oracle Database Access for Regulatory Compliance

    by Robert Buda | Apr 9, 2015 | Oracle DBA

    Reading Time: 2 minutes Data stored in corporate databases is subject to increasing regulatory scrutiny. To ensure compliance with security guidelines in major regulations like SOX, PCI, HIPAA and FISMA, you need to implement controls not only to protect data from unauthorized access, but also to monitor and report on access when it occurs. This capability, usually referred to as data access auditing, enables you to produce an audit trail regarding reads and writes to your Oracle database data……

    Read more Add new comment
  • 7 New Offerings: Oracle Steps Up Its Big Data Game

    by Robert Buda | Apr 1, 2015 | Oracle DBA

    Reading Time: 3 minutes For any big data effort to succeed, an organization needs to figure out how to combine the right data from the right sources to generate the right insights to achieve its goals. Transactional applications might hold data on customer purchases, for instance. But their browsing patterns, loyalty interactions and responses to tweeted offers are probably in web-based systems. You need to pull all the pieces together to solve the puzzle and exploit new opportunities. Oracle…..

    Read more Add new comment
  • Still Think Your Business is Too Small for Big Data?

    by Robert Buda | Mar 25, 2015 | Oracle DBA

    Reading Time: 3 minutes Just because your business isn’t that big doesn’t mean you don’t have “big data” issues or a need for big data-style analytics to remain competitive. “Big data” is a relative term—relative to needs and capabilities for making business decisions, that is. Nearly every organization, whatever its size, will sooner or later reach the point where the volume, variety and velocity of the data it needs to analyze exceeds its storage and/or computational capacity, such that…..

    Read more Add new comment