Database Blog


  • Database Patch News — February 2020 (Issue 2)

    Feb 19, 2020

    Reading Time: 2 minutes Welcome to Database Patch News, Buda Consulting’s monthly newsletter of current patch information for Oracle and Microsoft SQL Server.

    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
  • 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
  • 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
  • How to Resolve Oracle Database Licensing Issues with Processor Cores in Virtualized Environments

    Mar 20, 2019

    Reading Time: 3 minutes This post focuses on Oracle database licensing by processor core, and explains a common mistakes administrators make when setting up a virtualized Oracle environment.

    Read more Add new comment
  • Why You Should Not Thin Provision Your Production Storage

    Feb 26, 2019

    Reading Time: 2 minutes Thin provisioning is a good option when used in a development environment or other scenario where only test data would reside on the virtual server. But it may not be not a good choice for production environments because of the high potential for downtime and data loss.

    Read more Add new comment
  • Architect Your Oracle Database for Efficient Backup and Recovery

    Aug 3, 2017

    Reading Time: 4 minutes 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 environment. Multi-terabyte databases are prevalent in all but the smallest organizations. Despite these large sizes, we tend to find that…..

    Read more Add new comment
  • Duplicating and Recovering Oracle Databases with RMAN

    Jul 5, 2017

    Reading Time: 5 minutes 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 has been around for quite a while. In addition to managing backups, it includes other functionality that helps with managing…..

    Read more Add new comment
  • Oracle Virtual Private Database — Granting Just Enough Access

    Jun 1, 2017

    Reading Time: 5 minutes 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 to sensitive data is critical. But facilitating the access to all the data that employees, customers, and vendors need to…..

    Read more Add new comment