Best Practices - Buda Consulting

Relational Database Design: It’s All About The Set

The Lost Science Of Relational Algebra And Set Theory I originally wrote this post in 2011. Much has changed in the database technology landscape since then. Big Data Technologies such as Hadoop have gone mainstream, cloud technology and is changing how and where we think about hosting our databases. But relational databases are still relied upon […]

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.

4 Keys to Avoiding the Number 1 Cause of Database Project Failure

At the end of the day, if we look beneath the surface-level issues, the main reason for database project failure — by far — is poor communication.

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.

5 Things to NEVER DO with Your Passwords

Even though we have all heard many times how important password protection is, we still see basic password protection rules broken ALL THE TIME. So here is a quick refresher.

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 […]