Database Patch News — March 2021 (Issue 7)
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
How Poor Communication Brought an Oracle System Down
A “lesson learned” on the importance of keeping your DBAs in the loop when making system changes, so you can avoid causing database issues.
Database Patch News — February 2021 (Issue 6)
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
Database Patch News — December 2020 (Issue 5)
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
Migrating an Oracle Schema to PostgreSQL with Partitioning Table(s) in an On-Premises Data Center
Many companies are looking for open source database solutions to help shrink the IT budget by minimizing or avoiding support costs. One such solution would be migrating an Oracle database to PostgreSQL. PostgreSQL is a widely used open source RDBMS, and the PostgreSQL database model is very similar to Oracle. All PostgreSQL features are available […]
Watch Your FRA!
Now the FRA may sound like a magical area that should never run into storage-related issues—but that could not be farther from the truth.
Database Patch News — June 2020 (Issue 4)
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
In-Place Oracle Database Encryption with Zero Downtime
Did you know that you can now encrypt existing tablespaces in-place, either online or offline in Oracle?
Database Patch News — May 2020 (Issue 3)
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
Schemas, Databases and Instances—Defined and Discussed
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.
