by Robert Buda | Aug 5, 2021 | Best Practices, Database Maintenance
In a recent blog post on database maintenance tips, I mentioned that one important facet of cleaning up the database is to remove records that we no longer need — those that don’t contribute value to the applications and users who use the database. This is an...
by Robert Buda | Jul 28, 2021 | Best Practices, Database Security
A colleague asked me today for my opinion on database security and the best way to grant a certain database privileges to a few users in a postgreSQL database. I will share my thoughts here and I welcome your thoughts as well. These basic database security concepts...
by Willie Gray | Jul 14, 2021 | Best Practices, Database Maintenance, Database Security
Why if it’s not broke don’t fix it does not work for databases (or anywhere in IT for that matter) One of the hotly debated items among IT professionals is the age-old question,”When should the database be updated?” At Buda Consulting we always like to...
by Robert Buda | Jun 22, 2021 | Backup and Recovery, Best Practices
What is a Disaster Recovery Plan The elements of a disaster recovery plan (also called a Business Continuity Plan) is a document that describes how an organization will survive a disaster. These can be natural disasters like hurricanes, fires, terrorist attacks, or...
by Willie Gray | Mar 18, 2021 | Best Practices, Database Patch News, database patching, Database Security, Oracle, SQL Server
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server. Here you’ll find information recently made available on patches—including security patches—and desupported versions. Why should you care...
by Robert Buda | Mar 18, 2021 | Best Practices, Database, MySQL, SQL Server
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...
