Database Blog
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...
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?
Is a Cloud Data Warehouse Right for My Company?
This post compares on-premises versus cloud data warehouse architectures and explains the pros and cons of each.
Is AI Going to Dumb Down the Internet?
Google’s new mobile-first index changes the way content relevance is derived. … I am not sure, but it sounds like that may mean that in order to get our pages to appear to the readers we want, we have to make it understandable (according to the AI) to the general public.
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.
Which Edition of Oracle RDBMS is Right for My Business?
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.
Oracle Active Data Guard Replication Error with Cisco Firewall: Root Cause and Workaround
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.
Ensure Redundant Database Coverage, During Covid-19 and Always
During this health crisis and always, ensure that at least two people know how to access and manage your database.
Test Your Disaster Recovery Strategies before Disaster Strikes
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!
It’s in the Database
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...
Database Patch News — February 2020 (Issue 2)
Welcome to Database Patch News, Buda Consulting’s monthly newsletter of current patch information for Oracle and Microsoft SQL Server.
Cloud Customers Need to Secure Their Own Data
The key takeaway is that if you have your data in any cloud service, you must be as rigorous in securing that data as if it were in your own data center—and in some cases even more so.
Communication Breakdown: Avoiding Conflict with Your Customers
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.
SQL Server Data Encryption Options
These days it’s only a matter of time before our firewalls or access controls are breached. Then what? In a multi-tiered security strategy, data encryption is a critical next line of defense.
Oracle Data Encryption Options
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?
Lock the Safe—Secure the Database
You are going away on a much-needed vacation to Aruba. You will only be gone for a week. But you understand the importance of security, so you make sure you lock the windows and doors. You put the lights on a timer so would-be thieves think there is some activity in...
GDPR Right to Be Forgotten and Other Access Rights
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.