Database Blog

  • 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
  • Database Downtime: Prepare For The Unexpected

    Jan 21, 2013

    Reading Time: 2 minutes Test your Assumptions: Database Backup and Recovery Every now and then something happens that really drives home the need to test and validate the assumptions that we have about the availability of our IT assets. I had an experience this week that brought to mind the importance of testing backup and recovery and business continuity plans. Planning At the beginning of each week, I look at each day’s activities and any travel that I need to…..

    Read more Add new comment
  • Relational Database Design: It’s All About The Set

    Dec 5, 2011

    Reading Time: 5 minutes The Lost Science of Relational Algebra and Set Theory. I originally wrote this post in 2011. Much has changed in the database technology landscape since then. Big Data Technologies such as Hadoop have gone mainstream, cloud technology and is changing how and where we think about hosting our databases. But relational databases are still relied upon as the best option for rich transactional data. So, since this technology is still the foundation of our mission critical…..

    Read more Add new comment
  • Why I Avoid Database Hints: a followup

    Jun 21, 2011

    Reading Time: < 1 minute In an earlier blog post about database hints, I gave a number of reasons why I dont like to use hints in SQL queries. Today I wanted to follow up to share one situation where I think hints are OK, even necessary. As described very well in an article in an article by Andrew Kelly in SQL Server Magazine (InstantDoc 129916),  hints are sometimes necessary when we wish to minimize logging during bulk loading operations……

    Read more Add new comment