by Robert Buda | Jul 15, 2020 | Best Practices, open source, Oracle, PostgreSQL
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...
by Robert Buda | Jul 10, 2020 | Backup and Recovery, Best Practices, Database, Oracle DBA
When it comes to Oracle database administration, one of the most revered parts of your database structure is the fast recovery area (FRA). This is an Oracle managed area where DBAs usually store some of the following files: Redo logs Archive logs Flashback logs...
by Robert Buda | Jun 8, 2020 | Best Practices, Database Security, Oracle
Have you been wanting to encrypt your Oracle database “since forever,” but feel like you just can’t afford the downtime? If a lot of data is involved, taking it all offline and encrypting it could be very time-consuming. So you’ve been putting the process off, while...
by Robert Buda | Apr 9, 2020 | Backup and Recovery, Best Practices, Database
One of the principles of Buda Consulting’s database coverage is that we always have at least two people who know your databases and your environment. This best practice is especially important at this time. In normal times, this helps with responsiveness and...
by Robert Buda | Mar 20, 2020 | Backup and Recovery, Best Practices, Oracle DBA
I’m sure you have heard—if not experienced—the following scenario. A student is working on a research paper and suddenly her PC crashes. Because she did not follow the golden rule of saving your document every sixty seconds, she lost hours of work. You would think by...
by Robert Buda | Mar 3, 2020 | Best Practices, Database Security, Oracle DBA
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...
