Database Blog

  • Test Your Disaster Recovery Strategies before Disaster Strikes

    Mar 20, 2020

    Reading Time: 2 minutes As the old saying goes, “It’s better to be safe than sorry,” and testing your disaster recovery data is essential to keeping you and your data safe!

    Read more Add new comment
  • It’s in the Database

    Mar 3, 2020

    Reading Time: < 1 minute Managed Health Systems of Indiana patient health information, July-September, 2019; Microsoft customer service and support records, January 22, 2020; Wyze email addresses, December 30, 2019; Georgia Tech student data, March 2019. What do all of these breaches have in common? The data that was stolen was inside a database. Yet when most companies think about data security, they still focus on securing the network, and spend very little time and energy making sure the databases—where…..

    Read more Add new comment
  • Communication Breakdown: Avoiding Conflict with Your Customers

    Dec 4, 2019

    Reading Time: 5 minutes This post describes two kinds of situations where conflict is likely to occur if we don’t handle things well, along with some thoughts about how to avoid conflict in these and other instances.

    Read more Add new comment
  • Oracle Data Encryption Options

    Nov 21, 2019

    Reading Time: 2 minutes Oracle offers various authentication and audit features to protect data from unauthorized access. But what about data at rest in operating system files, backups or other storage media?

    Read more Add new comment
  • GDPR Right to Be Forgotten and Other Access Rights

    Oct 31, 2019

    Reading Time: 7 minutes To ease compliance with Article 15, 16, and 17 of GDPR, and to support compliance with other GDPR Articles, we recommend the following steps with regard to handling of personal data.

    Read more Add new comment
  • Database Patch News — November 2019 (Issue 1)

    Oct 29, 2019

    Reading Time: < 1 minute Welcome to Database Patch News, Buda Consulting’s monthly newsletter of current patch information for Oracle and Microsoft SQL Server. Here you’ll find information on available patches—including security patches—and desupported versions made available during the past month.

    Read more Add new comment
  • Why Your Database Management Team Should Regularly Double-Check Your Backups

    Sep 30, 2019

    Reading Time: 3 minutes I’ve blogged before about the importance of checking database backups. Over 90% of new clients that we assess have backups that are either incomplete or totally unusable (true statistic!). The following story of a backup failure that happened recently—and the successful double-check by our DBA Scott)—provides a noteworthy example of how bad backups can happen even when you think your process is working. Recently we had a client that was looking to reduce storage costs…..

    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