-
In-Place Oracle Database Encryption with Zero Downtime
Jun 8, 2020Reading Time: 2 minutes Did you know that you can now encrypt existing tablespaces in-place, either online or offline in Oracle?
Read more Add new comment -
Database Patch News — May 2020 (Issue 3)
May 13, 2020Reading Time: 2 minutes Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
Read more Add new comment -
Schemas, Databases and Instances—Defined and Discussed
May 12, 2020Reading Time: 5 minutes What is a schema as opposed to a database as opposed to an instance? And how do schemas differ between Oracle and MSSQL? Or between Oracle and PostgreSQL? Or between PostgreSQL and MongoDB?These terms are very important when planning a database architecture, so let’s explore them.
Read more Add new comment -
Which Edition of Oracle RDBMS is Right for My Business?
May 11, 2020Reading 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, 2020Reading 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 -
Database Patch News — February 2020 (Issue 2)
Feb 19, 2020Reading 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, 2019Reading 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, 2019Reading 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, 2019Reading 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, 2019Reading 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