Database Blog

  • Which Edition of Oracle RDBMS is Right for My Business?

    May 11, 2020

    Reading Time: 8 minutes Do I really need Oracle Enterprise Edition? Do I need Oracle Enterprise Edition in order to have a standby database? What version of Oracle do I need? Oracle’s editions and features can be a bit overwhelming. This post shares some key information that I hope will make your choice easier.

    Read more Add new comment
  • Oracle Active Data Guard Replication Error with Cisco Firewall: Root Cause and Workaround

    Apr 22, 2020

    Reading Time: 2 minutes One of our customers had issues over the past several months with Oracle Active Data Guard replication to a standby server. The database on the standby server would intermittently fall out of sync with the database on the primary server, and log files were not consistently shipping to the standby server.

    Read more Add new comment
  • Ensure Redundant Database Coverage, During Covid-19 and Always

    Apr 9, 2020

    Reading Time: 2 minutes During this health crisis and always, ensure that at least two people know how to access and manage your database.

    Read more Add new comment
  • An Overlooked Oracle Management Task—Support Identifier Management

    Jul 19, 2019

    Reading Time: 2 minutes An often overlooked task that can cause problems outside of your RDBMS environment is managing your Oracle customer support identifiers (CSIs). This post offers best practices to prevent CSI-related issues.

    Read more Add new comment
  • Does Data Governance Make You Shudder?

    Jun 24, 2019

    Reading Time: 4 minutes At a recent vendor conference, I found myself talking with a varied group of technology professionals. Two were technology generalists, one was a data engineer, one was responsible for transportation technology at a major university (think autonomous vehicles, traffic sensors, etc.), another was responsible for university student and teacher data (lesson plans, research findings, etc.), and one was responsible for his organization’s IT security.  During the conversation, someone mentioned data governance. Immediately there was a…..

    Read more Add new comment
  • SQL Server Contained Databases and Oracle Multitenant: Advantages Compared

    Apr 18, 2019

    Reading Time: 2 minutes In short, the main goal of multitenancy is to facilitate database consolidation, while the main purpose of contained databases is to enable isolation and thus portability. Yet each approach addresses both these concerns.

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

    Sep 23, 2016

    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
  • Using the Data Dictionary to find hidden data in SQL Server

    Jul 12, 2013

    Reading Time: 2 minutes A client asked me recently how he could find a string in his SQL Server database without knowing what table or column it was in. The string was a translation of a code that appeared on one of the UI screens. This was a packaged CRM database and he had no documentation on the schema. With hundreds of tables whose names were not obvious, he had no idea where the translation might be kept, but…..

    Read more Add new comment
  • MySQL Parser Deficiencies

    Jul 5, 2013

    Reading Time: 3 minutes MySQL is a very popular database for many applications. But the parser has some important deficiencies that developers need to be aware of. The parser is inconsistent and not robust in the way that it enforces statement syntax. This may lead to ambiguity and application defects that are very difficult to find. I include one example below and link to another blog article that discusses another. Inadequate Group By Parsing The MySQL group by function…..

    Read more Add new comment
  • Total System Failure: Why you should validate your database backup

    Apr 23, 2013

    Reading Time: 3 minutes Every now and then things happen that make us realize how important double checking things can be. I had a recent experience in which four unrelated parties (including me) did the wrong thing regarding one business transaction. If any one of us had done the right thing, there would have been no problem. But all four parties dropped the ball, causing potentially serious problem. This is why it is important to leave nothing to chance……

    Read more Add new comment